Multi-row Formula not working for the last row

[donne4real]

I am trying to use the Multi-row formula to determine the value in the Determination column in the table below.

The rule is if the date is the same and Participant ID is the same but the Position is different, Determination column is Unsteady.

If the Date is the same and the Participant ID is the same and the Position is the same, then the Determination is Steady.

I have not been able to successfully get this to work. In each instance, the last value (highlighted in bold) is always showing the incorrect value.

Participant ID	Date	Position	Determination
A	3/1/2021	Gold	Unsteady
A	3/1/2021	Silver	Unsteady
A	3/1/2021	Bronze	Unsteady
B	5/2/2021	Gold	Steady
B	5/2/2021	Gold	Steady

*** I have included the workflow.

[apathetichell]

have you checked out my workflow? In your workflow you shouldn't be grouping by participant ID... Screen grab attached shows what you want in your multi-row...