Convert the numbers from a column to negative values

[soncoku]

Greetings everyone.

I have two columns. One is Withdraw and the other one is Deposit.
As you can see only one of them can have data in one row.

I want to create a new column called Amount which would store the value of the column which has data.

BUT...

If it is from Withdraw I need to convert it to a negative value

if it is from Deposit it should stay positive.

Can anyone help me with such a formula?

[RolandSchubert]

Hi @soncoku ,

you could try the formula:

ToNumber([Deposit]) - ToNumber([Withdraw])

Let me know if it works for you.

Best,

Roland

[soncoku · Accepted solution]

apparently it was easy, I just needed a coffee.

Cheer everyone.

iF [Withdraw]!=Null() THEN [Withdraw]*-1 ELSE [Deposit] ENDIF