if condition on AGGR

[manojciti]

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

[QFabian · Accepted solution]

Hi @manojciti  please try something like this :

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

=

[manojciti]

Fantastic! It works. 

Cheers!