Multi Row Formula to keep One Value only in the 1st Row

[DataPirate26]

Hi all,

I need one help with the multi Row Formula. I have attached a small workflow where I need to Update the Standard Hours Field.

For Each Staff ID and for Each month I need the Standard hours only for the 1st row and rest will be blank. 

Note: I will Run this workflow through an App. So even we can have Data for only a particular month for Example it can have data only for the Month of July or August. Also it can have data for 5 months. So the Multi Row Formula needs to be built as such it doesn't impact when it will have only data for a Single month. 

[ShankerV · Accepted solution]

Hi @DataPirate26 

Please find the desired output.

IF [Row-1:Staff Name]!=[Staff Name] or [Row-1:Month ]!=[Month ]
THEN [Standard Hours]
ELSE null()
ENDIF

Many thanks

Shanker V

[PangHC]

to avoid sorting issue,

we can generate id for by each staff, month and year. then add another formula tool to keep when ID=1