Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Splits debits and credits into two columns

JanaZ
7 - Meteor

Hi Everyone, 

 

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

 

Thanks

Jana

5 REPLIES 5
AndrewBanh
9 - Comet

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
17 - Castor
17 - Castor

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
7 - Meteor

Thanks Andrew.

JanaZ
7 - Meteor

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
17 - Castor
17 - Castor

Hi @JanaZ ,

 

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

 

Best,

Fernando V.

Labels