topic Re: Totals Function Count in KPI in App Development

Totals Function Count in KPI

JASalinas — Wed, 18 Jan 2023 02:14:22 GMT

Hi friend, I have the next set analysis in the table chart:

if(((Sum({<[ACCNT_CODE]={"611110"}, [FNCT]={"DT*"}, [ORGID]={"T*"}, [PROJ]={"Y2022"}, [LEDGER]={"A"}>}[AMOUNT]) /
(Sum({<[ACCNT_CODE]={"611110"}, [FNCT]={"DT*"}, [ORGID]={"T*"}, [PROJ]={"Y2021"}, [LEDGER]={"A"}>}[AMOUNT]))) -'100%') >= '8.38%',
((Sum({<[ACCNT_CODE]={"611110"}, [FNCT]={"DT*"}, [ORGID]={"T*"}, [PROJ]={"Y2022"}, [LEDGER]={"A"}>}[AMOUNT]) /
(Sum({<[ACCNT_CODE]={"611110"}, [FNCT]={"DT*"}, [ORGID]={"T*"}, [PROJ]={"Y2021"}, [LEDGER]={"A"}>}[AMOUNT]))) -'100%'))

if Total function is Auto tha value is 0.17 but if Total Function is Count the value is 867, I want the value 867 in a KPI, the same set analysis in the KPI the value is 0.17

Help me please!...

Thak you in advanced for your help...

Re: Totals Function Count in KPI

Digvijay_Singh — Wed, 18 Jan 2023 03:14:09 GMT

May be try like this -

Sum(Aggr(<Your expression>,description)), 'description' as I see is your chart dimension

Re: Totals Function Count in KPI

JASalinas — Wed, 18 Jan 2023 03:42:02 GMT

Thank you fot you answer, yes I did that

=sum(aggr(if(((Sum({<[ACCNT_CODE]={"611110"}, [FNCT]={"DT*"}, [ORGID]={"T*"}, [PROJ]={"Y2022"}, [LEDGER]={"A"}>}[AMOUNT]) /
(Sum({<[ACCNT_CODE]={"611110"}, [FNCT]={"DT*"}, [ORGID]={"T*"}, [PROJ]={"Y2021"}, [LEDGER]={"A"}>}[AMOUNT]))) -'100%') >= '8.38%',
((Sum({<[ACCNT_CODE]={"611110"}, [FNCT]={"DT*"}, [ORGID]={"T*"}, [PROJ]={"Y2022"}, [LEDGER]={"A"}>}[AMOUNT]) /
(Sum({<[ACCNT_CODE]={"611110"}, [FNCT]={"DT*"}, [ORGID]={"T*"}, [PROJ]={"Y2021"}, [LEDGER]={"A"}>}[AMOUNT]))) -'100%')), ORGID))

But I get the next value

And must be 867...

Re: Totals Function Count in KPI

Digvijay_Singh — Wed, 18 Jan 2023 03:48:15 GMT

If possible, can you export the data and see if 867 is a sum of all numbers or a count of all numbers. Its a little hard to understand if its just a count of all numbers because I see SUM in the actual expression being used.

Also whats ORGID? I see you have description in the chart, I am not sure if using actual chart dimension can make any difference.

If possible, please share a data sample or sample app to look further to provide needed solution.

Thanks,