Splitting the amount (positive and negative)

[SH_94]

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.

[atcodedog05 · Accepted solution]

Hi @SH_94 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @SH_94 

Cheers and have a nice day!