2 Replies Latest reply: Sep 16, 2015 10:33 AM by Linda Diodato RSS

    Rank results of different calculations

    Linda Diodato

      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