Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try,
Create a chart
Dimension:
YourDimesion
Expression:
=rangemax(sum(A)*$(vSVC1),sum(B)*$(vSVC2),sum(C)*$(vSVC3),sum(D)*$(vSVC4))
try,
Create a chart
Dimension:
YourDimesion
Expression:
=rangemax(sum(A)*$(vSVC1),sum(B)*$(vSVC2),sum(C)*$(vSVC3),sum(D)*$(vSVC4))
Brilliant!
Thanks 🙂