Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Solved:
Sum(aggr(Count({<DateType={'Application_Date'}>}distinct [Application No.])
* sum(COST_OF_SERVICE),COST_OF_SERVICE))
Solved:
Sum(aggr(Count({<DateType={'Application_Date'}>}distinct [Application No.])
* sum(COST_OF_SERVICE),COST_OF_SERVICE))