Hi,
I have a bug in my process, hoping somebody could help please.
I have two fields, Color and Fruit. I made a process to only show the first entry of that column so I used a Mult-Row formula on each field to number each specific entry:
I'd like the final result to look like this:
IF [Color] == [Row-1:Color]
THEN [Row-1:ColorNumber]+1
ELSE 1
ENDIF
IF [Fruit] == [Row-1:Fruit]
THEN [Row-1:FruitNumber]+1
ELSE 1
ENDIF
I then used another two Multi-Row formulas to update the fields by removing numbers greater than 1:
IF [ColorNumber] > 1
THEN NULL()
ELSE [Date]
ENDIF
IF [FruitNumber] > 1
THEN NULL()
ELSE [Country]
ENDIF
As you can see above this works for Color but when there isn’t a change of Fruit for a new Color then this doesn’t work (highlighted cells). How could I change the formulas to make this work?
Thanks.
