Count if and measurement

[guidodepauw]

I want to make a formula that count my Key_accounts based on difference of two measurements :

if(fAbs(sum(distinct CARRYING_AM)-sum(CRRYNG_AMNT))>'1000',count (distinct [%Key]),0)

[lironbaram · Accepted solution]

Hi 
this expression should work

sum(aggr(if(fAbs(sum(distinct CARRYING_AM)-sum(CRRYNG_AMNT))>1000,1,0), [%Key]))

[guidodepauw]

It works many thanks