Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi
this expression should work
sum(aggr(if(fAbs(sum(distinct CARRYING_AM)-sum(CRRYNG_AMNT))>1000,1,0), [%Key]))
Hi
this expression should work
sum(aggr(if(fAbs(sum(distinct CARRYING_AM)-sum(CRRYNG_AMNT))>1000,1,0), [%Key]))
It works many thanks