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?