Thing's Value is Max without Tie

benjamin1 · 2020-06-12T15:03:09.542Z

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

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

benjamin1 · 2020-06-13T09:22:47.478Z

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

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.

system · 2020-08-21T15:03:11.546Z

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