muti row formula question

[ryanzhang487]

Hi community,

I would like to create a column in alteryx (highlight in yellow) saying that when [stardard time hrs] column is 0 then the row above will be the last step else null

Thank you for your help

[ShankerV · Accepted solution]

Hi @ryanzhang487 

Please find the expected output.

[binuacs · Accepted solution]

@ryanzhang487 One way of doing this by grouping the Work Type in the Multi-Row tool