How can I test my highest value logic for reliability and repeatability?

The max value score is giving unexpected values. In the last test of the scores to see which one is the highest score in a default order I was expecting connection (which is the highest order) and got momentum. I would love some help figuring out how to make this logic repeatable.

I think I have it. I used a set of nested if statements to break ties. It appears to work. If you'd like to take a look to validate that would be helpful. Thank you in advance.

Hi SmootMiddleton,

Thanks for reaching out to us for help. Regarding your highest value logic and ensuring its reliability and repeatability, it looks like you are on the right track by using nested IF statements to break ties. This approach is effective for handling cases where multiple values might be equal, and you want to prioritize one over the other.

In Jotform, you can use logical functions such as IF, AND, OR, and SWITCH within your calculations or conditional logic to create complex decision trees that ensure consistent results. For example, the IF function can return different values based on whether a condition is true or false, which is useful for tie-breaking scenarios.

Let us know if you have any questions.