Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Need Formula Trick to Calculate Debit (Only Using Qty & Amount)
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 + y
x - y
x * y
x / 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?