Splits debits and credits into two columns

[JanaZ]

Hi Everyone, 

I am hoping someone can help me with a workflow that splits debits and credits into separate columns

Thanks

Jana

[AndrewBanh · Accepted solution]

Hi @JanaZ 

You can use a formula tool and create a Debit and Credit column.

Debit formula: 

if [Amount] >= 0

then [Amount]

else null()

endif

Credit formula:

if [Amount] < 0

then [Amount]

else null()

endif

Let me know how you go 🙂

Andrew

[fmvizcaino · Accepted solution]

Hi @JanaZ ,

Attached is an example showing how to accomplish this.

If that is what you are looking for, please mark the answer as correct, if not, let me know what I can do to help you further.

Best,

Fernando V.

[JanaZ]

Thanks Andrew.

[JanaZ]

Hi,

How can i make the debit amount in the debit column without the minus sign?

do i need to do another formula?

thanks

Jana

[fmvizcaino]

Hi @JanaZ ,

What you can do is to multiply [Debit]*-1

Best,

Fernando V.