Please kindly assist me in writing the expression correctly .?

[suvechha_b]

Hi All ,

Please kindly assist me in writing the expression correctly . I am attaching my sample model. I trying to explain what I need as my result.

For eg,

Client Id - 9910206389188 , I have only one deal_id 13067504 but the dealstate_id is 71 and 33 .

So, my requirement is on the `Wesbank DIC ` for report ' One month select DIC Overview' -

it should on have - DIC amount as - 5677.47 for any one of the dealstate_id for unique deal_id .

But the report ' One month select DIC Overview'  is summing up to R 11354,94

Where as , its not the case for the other ClientID - 9805290108086 and dea_id - 12757731

For eg,

There is such case , where deal_id is different and dealstate is also different , see below screenshot - in such scenario , the 'Wesbank DIC' is working correctly.

Sample attached.

Thanks in advance.

[PrashantSangle · Accepted solution]

use distinct before if statement like

=sum({<bank={'Wesbank'}> }DISTINCT if(LatestForPodium ='1' or LatestForState ='1', dicAmount))

Regards,