Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 18, 2026, at 8:00 PM Pacific Time, our Case Management System will undergo a scheduled maintenance for approximately 15 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Reg: Saved search using formula and summary "group"
Hi Team,
I need to create a saved search in NetSuite to report on purchase orders for a specific month, broken down by amount range. The goal is to see:
- How many purchase orders were created in each range
- The total spend (sum of amount) for each range
The amount ranges should be as follows:
- €0 – €1,000
- €1,000 – €5,000
- €5,000 – €10,000
- Over €100,000
I was getting an error while I added the formula text with summary as "group"
The result field Formula (Text) cannot be grouped. Please edit the search and omit this field or use a different summary function
0