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
Solved! Go to Solution.
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