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!
Search Minimum Value across multiple custom fields
Trying to and need help writing a formula or finding another way to return the minimum value, that is not 0 or empty, of multiple custom fields.
Basically, we have set up a Vendor Quantity Pricing custom form, that has multiple prices for buying in various quantities. Sometimes Price B may be lowest, sometimes Price C. Many are often empty. I'd like to come up with a saved search that returns one value for each record, that searches these multiple prices and finds the lowest that is not 0 or empty.
Any help appreciated!