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!
Grouping Using a Formula vs. Summary Type On Results Page
All,
I'm having a difficult time with a search which seems pretty basic and hoping someone can help me.
I want to use a CASE statement that will allow me to group sales orders then sum the amount and if greater THEN 500 throw a 1 if not throw a 0.
Example (using formula numeric):
CASE WHEN [Group] {number} sum({amount})>500 THEN 1 ELSE 0 END
I could easily group on name or number the problem is I dont want to see all the names/numbers only aggregate data.
There has to be away to group in a formula versus using the drop down summary type on the results page of a saved search. Any help would be great!