Grouping Duplicate Values

krishnagandhi

So i was trying to have different group numbers for any data that is duplicated. I wrote a multi-row formula, but there is something i am not doing right.

Here is what i am trying to achieve

i can't for the life of me figure out what i am doing wrong with the formula: [Row-1:Duplicate]+iif ([Third_Party_Invoice_Number]=[Row-1:Third_Party_Invoice_Number] AND [Subtotal pre markup] = [Row-1:Subtotal pre markup] AND [Work_Date] = [Row-1:Work_Date] = 1,0,1)

I have attached the workflow. Any help would be appreciated

Grouping Duplicates.yxmd

gabrielvilella

Hey @krishnagandhi, here is how you can do this. I also added another option using the Tile tool. And I noticed that you have some line breaks.

Formula for the multi-row:

IF [Row-1:Third_Party_Invoice_Number]=[Third_Party_Invoice_Number]
THEN [Row-1:Duplicate]
ELSE [Row-1:Duplicate]+1
ENDIF

Grouping Duplicates.yxmd