How to create formula from 1 column become 2 columns

[Lydieatantra]

Hi Alteryx Team,

Kindly need your help to create the workflow as attached below, since im newby in Alteryx.

Current

GL Amount

1000

2500

-2000

-1500

Expected

GL Amount	Incoming	Outgoing
1000	1000
2500	2500
-2000		-2000
-1500		-1500

Thank you.

Lydiea

[Lydieatantra]

Hi @grazitti_sapna ,

Thank you for your advise.

Then can we still use the ABS formula ? Because i see that the formula will be create the result is always as a positif amount.

If you dont mind, could you please tell me what the meaning of this function ?

ABS([Row-1:Value])-[Value]

Thank you and regards,

Lydiea

[grazitti_sapna]

Hi @Lydieatantra , as per your query you need Different=Bank Movement - GL Movement in order to achieve this goal multi row formula tool has to be applied as it is row level calculation.

Please refer to the screenshot.

Also, when you apply this formula [Row-1:Value]-[Value] when your value will be Row 1 that is Source= Bank and Value= 2000 it will return a value as -2000 as per the mentioned calculation, as there is no value before Source Bank hence, it will do calculation as 0-2000=-2000. In order to get the exact answer I have used ABS([Row-1:Value])-[Value] to convert the -2000 value to positive so that you can get the desired result.

Then I have transformed the data a bit.

I hope this helps you.

Thanks.

[grazitti_sapna]

Hi @Lydieatantra , try this solution as well I believe this will give you more accurate records than multi-row formula tool. Try using different use cases to check if the end result is what you expect.

Thanks.