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!
Saved Search Formula for Unit Price based on Item Current Standard Cost
We have a Saved Pricing Search with a couple of fields and formulas.
The problem formula is the last one.
We want to know the percentage of the Unit Price based on the Item Current Standard Cost
Example:
Unit price: 187
Item Current Standard Cost: 93
Expectation: 187/93*100 = 201%
Reality: There is a divide by zero error in this search. It may be an error with a formula you have used.
I can't seem to work out where the problem is coming from. I have a feeling it's because I want to use results of other fields in the same Saved Search but i'm not sure.