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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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