Splitting the amount (positive and negative)

Question

Dear community,

May i know how can we split the negative and positive amount and then categorise them into two different column as per screenshot below:

I have also attached the file below for your reference.

Splitting Amount.xlsx

atcodedog05 · Accepted Answer

Hi @SH_94

Here is how you can do it.

Workflow:

Hope this helps : )