Thing's Value is Max without Tie

As a condition to a workflow, I want to check whether a Thing’s Score is the maximum value among a list of Things, but also that this Thing’s Score is not tying with another Thing’s equal score.

Hence:
When Thing’s Score is Do a Search for Things’s Score:max and … ?

I’m stuck with the second clause of this condition :thinking:

Example tests:

  • IF Things’s Score is 7 and Things’s Score:max is 8 THEN FALSE
  • IF Things’s Score is 8 and Things’s Score:max is 8 and Thing’s Score:converted to list is {8;8;4;3} THEN FALSE
  • IF Things’s Score is 8 and Things’s Score:max is 8 and Thing’s Score:converted to list is {8;7;4;3} THEN TRUE

Any suggestions? Thanks

1 Like

Okay! Once more, I think I figured things out by myself :nerd_face: thanks team :stuck_out_tongue_winking_eye:

And the magical formula is (drum rolls):

Condition: Thing’s Score is Do a Search for Things’s Score:max AND Do a Search for Things’s Score:filtered[constraint: this number is Do a Search for Things’s Score:max]: count is 1.

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.