Show only the result with the higher percentage

  • Hello there,

    Trying to configure the formula to show a test result based on the highest percentage of test scales.

    In my case the test scales are the same of test results (I have 6 scales and 6 results)

    Sometimes the formula works but in other cases it doesn’t work. I’ll explain it below

    For result-1 the formula is:
    scale-1 > (scale-2 + scale-3 + scale-4 + scale-5 + scale-6)

    (Same formula for the other 5 results. Of course, changing the first variable)

    What I pretend is to show a result based on the highest percentage of a scale. If scale-1 has the highest percentage, result-1 should appear. Although it works sometimes, it doesn’t work in all cases.

    For example, I can’t see any result when I have the following scales in the final result of the test.

    Scale-1=50%
    Scale-2=25%
    Scale-3=33%
    Scale-4=0%
    Scale-5=0%
    Scale-6=0%

    Any ideas of what I can do? Hope you can help me.

    Thank you in advance

    • This topic was modified 2 years, 10 months ago by santy4tas.
Viewing 1 replies (of 1 total)

  • Привет!
    Была похожая проблема, у меня получилась такая формула, но возможно она не подойдет:
    scale-1 => scale-2 AND scale-1 => scale-3 AND scale-1 => scale-4 AND scale-1 => scale-5 AND scale-1 => scale-6
    scale-2 => scale-1 AND scale-1 => scale-3 AND …….

Viewing 1 replies (of 1 total)
  • The topic ‘Show only the result with the higher percentage’ is closed to new replies.