Split one field based on another

swiles

Hello,

I have data that I need new fields created based on the value in one field. If the value in the “isEnding” field is TRUE, then I need the amount to go to a new field “Ending”. If the value in “isEnding” is FALSE, then I need the amount to go to a new field “Beginning”. Attached is an Excel file with two worksheets, the Input and the desired output.

Thanks in advance for any suggestions!

Scott

Test.xlsx

ChrisTX

Use the Formula tool to create two new fields

Beginning formula   If [isEnding] = 0 Then [Amount] else Null() Endif

Ending formula   If [isEnding] = 1 Then [Amount] else Null() Endif