KPI not showing correct number (Expression)

Alarkis — Sat, 16 Nov 2024 18:18:13 GMT

Hello,

I have a KPI that is not showing correct result

Image below:

as you can see the TOTAL_COST result is wrong

the expression is (COST_OF_SERVICE * Number)

This is the expression used:

Count({<DateType={'Application_Date'}>}distinct [Application No.])
*
sum({<DateType={'Application_Date'}>}COST_OF_SERVICE)

Re: KPI not showing correct number (Expression)

Alarkis — Wed, 29 Jul 2020 10:57:09 GMT

Solved:

Sum(aggr(Count({<DateType={'Application_Date'}>}distinct [Application No.])
* sum(COST_OF_SERVICE),COST_OF_SERVICE))