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!
Help Combining two formula's that work seperately
I may be missing something but I have two formula fields on a search that execute correctly when on individual lines.
The problem is when I try to combine them to one line I get an Error message, what am I doing wrong?
(First One)
type = Formula (Numeric)
Summary type = Maximum
Formula = (nvl({item.quantityonhand},'0')+nvl({item.quantityonorder},'0'))
(Second One)
type = Formula (Numeric)
Summary type = Maximum
Formula = sum({quantity})
ATTEMPTED FORMULA:
type = Formula (Numeric)
Summary type = Maximum
Formula = (nvl({item.quantityonhand},'0')+nvl({item.quantityonorder},'0'))-sum({quantity})
This one gives me an Error message.