Hi Everyone,
I am hoping someone can help me with a workflow that splits debits and credits into separate columns
Thanks
Jana
Solved! Go to 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
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.
Thanks Andrew.
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