topic Re: Count if and measurement in App Development

Count if and measurement

guidodepauw — Fri, 03 Jun 2022 07:46:53 GMT

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 — Fri, 03 Jun 2022 11:07:23 GMT

Hi
this expression should work

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

guidodepauw — Fri, 03 Jun 2022 13:59:43 GMT

It works many thanks