Assigning different identifiers based on Row-1

[carterfleming]

I'm trying to assign GL account numbers based on what is contained in the row above a specific line. See screenshot for example, I've scrubbed my company's info out of it but the premise is the same. The first table shown is the current state of my workflow and the second table is what I'm trying to do. I need to change the GL column of the [Null] rows to specific GL accounts based on the GL account above it. For example, "if the above row's GL column is '123.2' then '361.1'" and on and on until all the [Null] rows have a GL column identifier assigned.

[PhilipMannering · Accepted solution]

Could you use the MultiRow Tool to add the previous two records together?

The formula would be,

if isnull([GL]) 
then [Row-2:GL] + [Row-1:GL]
else [GL]
endif

Example attached

[carterfleming]

The formula isn't an addition of the two rows above it. Maybe I used a bad example, but there are specific GL numbers that I need to assign. 

[carterfleming]

Nevermind, I can use @PhilipMannering Multi Row formula and then add a Formula tool on the end to get what I want with if statements. Thanks!

[PhilipMannering]

Let me know if it doesn't work, and we can figure out another solution.