Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Maguelonne
Contributor
Contributor

Fix KPI in a aggr function

Hello all, 

I would like to fix a KPI whatever the filters selected. 

To count the number of unique X it works: Count(Distinct{1}(X)) but I am not able to fix the expression below:

sum(aggr({1}WE_Total_Cost_Max, PN1,PN2))

Thanks 

Labels (3)
2 Replies
Or
MVP
MVP

Why are you summing aggr()? Why not just sum the value?

Maguelonne
Contributor
Contributor
Author

because I can have duplica such as:

total cost=5, PN1=a, PN2=b, c=x1

total cost=5, PN1=a, PN2=b, c=x2 

and I would like to have the total cost=5  and not 10. it is why I take the sum aggregated on PN1 and PN2