Hi DNA Team,
I’ve stuck on something tiny but I don’t understand why the formula does not work as I want to.
Debit Credit.xlsx (18.0 KB)
The attached file data contains 3 rows in query editor I would like to add 4th column call Amount
I tried to write if statement if Debit > 0 then Debit else -1 * Credit but I didn’t get the correct result.
I will appreciate your help.
I would like to have Values of Debit and Credit in one Column whereas Credit needs to be negative.