topic Re: if condition on AGGR in App Development

if condition on AGGR

manojciti — Tue, 29 Mar 2022 08:08:06 GMT

HI,

I have 2 expression to show count of name which is having percentage calculated(amnt2/amnt1) which is >80 and less than 50 but now i want 3rd expression to show percentage (amnt2/amnt1) should be >50 and <80

Sum(Aggr(If((amount2/[amount 1])*100 > 80, 1, 0), name))

Sum(Aggr(If((amount2/[amount 1])*100 < 50, 1, 0), name))

Appreciate response !

Regards

Manoj

Re: if condition on AGGR

QFabian — Tue, 29 Mar 2022 22:57:32 GMT

Hi @manojciti please try something like this :

Sum(Aggr(If((amount2/[amount 1])*100 >= 50 and (amount2/[amount 1])*100 <= 80, 1, 0), name))

Re: if condition on AGGR

manojciti — Wed, 30 Mar 2022 06:19:52 GMT

Fantastic! It works.

Cheers!