Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Thank you.
rangemax(sum(F1),sum(F2),sum(F3))
May be this
Sum(RangeMax(F1, F2, F3))
How it should be 9 can you explain this please for understanding. Will it be maximum values for all three fields that is (3+3+3).
F1=1+2+4
F2=1+2+3
F3=2+3+4
the sum of F3 is the maximum this is what I want to show
May be this
RangeMax(Sum(F1), Sum(F2), Sum(F3))
rangemax(sum(F1),sum(F2),sum(F3))
Where you want to use this expression.
Thank a lot this worked
Thanks a lot this worked
They are individual fields then try only this expression in any text object or the KPI object
=RangeMax(Sum(F1), Sum(F2), Sum(F3))
Or
=Sum(RangeMax(F1, F2, F3))