Need a count of a calculated measure

[#1]

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

[sunny_talwar · Accepted solution]

Try this

Count(DISTINCT {<name = {"=(amount2/[amount 1])*100 < 100"}>}name)

or this

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

[#3]

Thanks Sunny. Appreciate your help.

[manojciti]

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

[manojciti]

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

[rajeshwar1]

what if my calculated measure already has set analysis in it