I am using this expression definition in IBM Cognos Report studio 11, and they gives me duplicates values.
I want to modify to eliminates the duplicates (I have an unique field call Account Number).
This is the expression definition:
CASE WHEN ( [GL Application Master Monthly].[GL Application Master Monthly].[Current Interest Rate] > 0 and [GL Application Master Monthly].[GL Application Master Monthly].[Current Interest Rate] <=3.75 and [GL Application Master Monthly].[GL Application Master Monthly].[GL Account Number] not in(1561162, 1590863, 1645463, 1698362, 1698664) ) THEN ([GL Application Master Monthly].[GL Application Master Monthly].[App Converted Yesterday Balance]) END