Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Alarkis
Contributor III
Contributor III

KPI not showing correct number (Expression)

Hello,

I have a KPI that is not showing correct result

Image below:

 

Alarkis_0-1595935437585.png

 

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)

 

 

 

 

 

Labels (5)
1 Solution

Accepted Solutions
Alarkis
Contributor III
Contributor III
Author

Solved:

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

View solution in original post

1 Reply
Alarkis
Contributor III
Contributor III
Author

Solved:

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