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

Question

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.

Multi Row Formula to Keep one Value.yxmd

ShankerV · Accepted Answer

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