Help with complex conditional logic with Security Question for double scores

@Liz @SchreberTech - i have done this - in part: the hard part is in the calculations of the ties - and the ‘number’ of ties. Unless you can guarantee that only a max of two variables can have a tie score, i think it works out that (out of 7 variables):

• there can only be one unique score of 6 (ie A is gt B and A is gt C… and A is GT G then go to ending A; same if B is greater than all the others) 
• if there is no unique high score, then you have to look at evaluating how many could have the same score: there are a possibilities that the high score in the variables could be at a ‘count’ of 5 or 4 for ties. 
• you would need to create some variables have the ability to record a ‘tie status’ 
  • ie v_is_A_tied_5, v_is_B_tied_5, etc as text variables and set them to ‘no’ to start with 
  • then when you do your logic rules, you establish if there is a unique count of 6, if not you check A to see how many times it is greater than the others, if it is 5, then once you are done the same for all the others, you need to do something like this: 
    • if A count is 5 AND A count = B count then replace v_is_A_tied_5 with tied-5 (and then replace v_is_B_tied_5 with tied-5)
    • to the same with the other variables to set the is_x_tied variables
    • then do the logic to determine which variables are tied at 5 and walk the path to the tie breaker question for 2 or 3 variable combinations would could be tied at 5 (A-b, a-c, a-d, etc… abc abd, abe… acd… 

it gets uglier if you have to go down to high score of 4 across the seven variables.