Rank results of different calculations

[#1]

Hi all,

I'm in a tricky situation and hope someone can help.

How do I rank the results of different calculations and just report the top value? All of this in the same expression if possible.

For example, I may have the following results:

sum(A) * vSVC1 = 5

sum(B) * vSVC2 = 3

sum(C) * vSVC3 = 2

sum(D) * vSVC4 = 0

In this case the expression result should be 5.

Please note the above variables can be changed by the user within an input box.

Thank you so much.

Linda

[Kushal_Chawda · Accepted solution]

try,

Create a chart

Dimension:

YourDimesion

Expression:

=rangemax(sum(A)*$(vSVC1),sum(B)*$(vSVC2),sum(C)*$(vSVC3),sum(D)*$(vSVC4))

[#3]

Brilliant!

Thanks 🙂