Hi
I suspect your issue was with how you separate the questions to be checked for max value
max( ${Q2_1} | ${Q2_2} | ${Q2_3} | ${Q2_4} | ${Q2_5} | ${Q2_6} | ${Q2_7} | ${Q2_8} | ${Q2_9} | ${Q2_10} | ${Q2_11} | ${Q2_12} | ${Q2_13} )
Your separator should be a comma between all the variables included as below
max( ${Q2_1}, ${Q2_2}, ${Q2_3}, ${Q2_4}, ${Q2_5}, ${Q2_6}, ${Q2_7}, ${Q2_8}, ${Q2_9}, ${Q2_10}, ${Q2_11}, ${Q2_12}, ${Q2_13} )
I made the changes as per attached excel and it worked just fine Ranking 02.xlsx (13.9 KB)
Stephane
