Hello.
I need some help with printing the two highest values out of five. I assume that max function can be used in expression manager. I know how to print one highest value, but I don't know how to print the second highest value.
For example,
using this code below, I can print the highest value
{if(A==max(A,B,C,D,E),"A","")}
{if(B==max(A,B,C,D,E),"B","")}
{if(C==max(A,B,C,D,E),"C","")}
{if(
=max(A,B,C,D,E),"D","")}
{if(E==max(A,B,C,D,E),"E","")}
So, if the A is the highest value among A, B,C,D, and E, then A will be printed. But, I also want to define that the second highest value is also printed.
Is there any ideas or suggestions how to do it?
Topic Author
