Required Debit credit column while looking positve and negative amounts

[Maheshp]

Hi Team,

I have a number in Alteryx like below.

Description	Numbers	BPC	Amount
Targeted Drug Delivery C	9783527347810	BC.538706.01	61.74
Targeted Protein Degradation C	9783527350131	BC.556738.01	-1502.31

But through formula i want to separate Debit and credit column while looking positive and negative sign of amount like below.

Description	Numbers	BPC	Amount	Debit	Credit
Targeted Drug Delivery C	9783527347810	BC.538706.01	61.74	61.74
Targeted Protein Degradation C	9783527350131	BC.556738.01	-1502.31		1502.31

Regards,

Mahesh

[Deano478]

Hey @Maheshp would something like this be of any help to you?

[BRRLL99 · Accepted solution]

In the formula tool, add the following columns:

• "Debit": IF [Amount] > 0 THEN [Amount] ELSE 0 ENDIF
• "Credit": IF [Amount] < 0 THEN ABS([Amount]) ELSE 0 ENDIF