Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have three columns in my data name , amount1 and amount2. I have created a new column with percentage as (amount2/amount1)*100. Now I want to display the total accounts with percentage < 100. I have attached the QVF file which shows it more clearly. Kindly help.
Thanks,
Mithun
Try this
Count(DISTINCT {<name = {"=(amount2/[amount 1])*100 < 100"}>}name)
or this
Sum(Aggr(If((amount2/[amount 1])*100 < 100, 1, 0), name))
Try this
Count(DISTINCT {<name = {"=(amount2/[amount 1])*100 < 100"}>}name)
or this
Sum(Aggr(If((amount2/[amount 1])*100 < 100, 1, 0), name))
Thanks Sunny. Appreciate your help.
HI Sunny ,
Can you help me with 3rd condition and help amend expression
Sum(Aggr(If((amount2/[amount 1])*100 > 80, 1, 0), name))
Sum(Aggr(If((amount2/[amount 1])*100 < 50, 1, 0), name))
and I need 3rd expression which will be between greater than 50 and less than 80 (50<exprsn<80)
Appreciate your help with this.
Regards
Manoj
what if my calculated measure already has set analysis in it