Assigning accounts and transaction types to data

Question

I have a small set of data that I want to assign accounts and transaction codes to, based on whether the account is <>0.

If the amount is >0, then I want to assign transaction code 05 to the ST account and 06 to the LT account

Data

Account mapping table

Desired output

Acct breakout.xlsx

tiverson · Answer

@binu_acs , your solution worked, I just needed to add a formula to switch signs with the LT account amount

binu_acs · Answer

@tiverson

account3.yxmd

CathyS_Slalom · Answer

Hi @tiverson, see attached example workflow.

New Workflow4.yxmd