Hi Community,
I was able to generate the Credit column using the Formula Type: Multiply (Qty * Amount), where only x (Qty) and y (Amount) are available for use.
Now I’d like to calculate the Debit, but I’m stuck — I can’t use any logical functions like IF or ABS, and I only have access to formula types like:
x + yx - yx * yx / y((x - y) / x) * 100, etc.
Has anyone managed to work around this in a customised report?
Is there a formula type or trick that could help me calculate the Debit, especially when Debit should only apply when Qty = 0?
Any suggestions would be greatly appreciated!
Best regards,
Mary
|
| Qty | | Amount | | Credit | |
|---|
|
| -1 | | -9,5 | | 9,5 | |
|
| 0 | | 59,5 | | 0 | |
|
| -1 | | -50 | | 50 | |