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!
Divide by Zero Errors, even with NULLIF or NVL
I'm trying to run a ratio division in a Saved Search where I take our quantities sold from last week and divide it by the average of quantities sold over the preceding 4 weeks. The formulas all work in custom fields and columns on their own so I know they're not the issue. But when I try to do a saved search to review all our items, I got the obvious "Possible Divide by Zero" error.
I've tried numerous combinations of NVL and NULLIF around the entire search formula, the denominator, the individual calculations in the denominator, etc., and they either give me the divide by zero or the whole thing errors out and won't calculate the report at all.