I am trying to get the maximum values for multiple fields is a table and display it in KPI.
for example : I have fields F1, F2, F3
F1 has values--> 1,3,4
F2 has values--> 1,2,3
F3 has values--> 2,3,4
so in this case KPI would show the maximum total of the 3 fields which is 9
can anyone please help.
Solved! Go to Solution.
They are individual fields then try only this expression in any text object or the KPI object
=RangeMax(Sum(F1), Sum(F2), Sum(F3))
=Sum(RangeMax(F1, F2, F3))