topic Re: Need a count of a calculated measure in App Development

Need a count of a calculated measure

Thu, 07 Sep 2017 16:05:28 GMT

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

Re: Need a count of a calculated measure

sunny_talwar — Thu, 07 Sep 2017 16:11:57 GMT

Try this

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

or this

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

Re: Need a count of a calculated measure

Thu, 07 Sep 2017 17:42:36 GMT

Thanks Sunny. Appreciate your help.

Re: Need a count of a calculated measure

manojciti — Tue, 29 Mar 2022 06:53:23 GMT

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

Re: Need a count of a calculated measure

rajeshwar1 — Wed, 16 Aug 2023 21:15:08 GMT

what if my calculated measure already has set analysis in it