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.
Group and Sum Opportunities by projected total brackets
Hello there, i'm trying to create a saved search which will group and sum opportunities by projected total, under the value criteria listed below, but have not been able to find anything relevant in Suite Answers, i'd be grateful for any suggestions on formulas which could do this, thanks for your help.
Below £10,000
Between £10,000 and £25,000
Between £25,000 and £50, 000
Between 50, 000 and £75,000
Over £100,000
0