How to get the total count with set analysis expression ?

[suvechha_b]

Hi All ,

How to work the total value of the count in the below expression - with set analysis -

if([Grand Total]<='250000', Count(Distinct UW_MONTH_CLAIM_TOTAL_KEY)) and 

How to get the Total correct -

if([Grand Total] <= '250000', (Sum([Latest Total Gross Paid]) + Sum([Latest Total Gross Outstanding])) ) 

Thanks in Advance

Suvechha

[bramkn · Accepted solution]

sum({<[Grand Total]={"<=250000"}>}....)

Is this what you try to do?

Or do you want sum(TOTAL .......)