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.
Calculating a ratio in a saved search
Hi All,
I have been stumbling around this problem for quite some time and logging into the user group is my last resort.
I have a report I need to create that will give me the opportunities won divided by all total opportunities. That will be on one column. On the second column will be the $ amount on the opp that are Status- Won divided by the dollar $ total of all opportunities. This will be further filtered by class and the classes will show on the first column of the results in the saved search. There is about 60 classes. I tried Kpi scorecards but you can only have 10 show on one scorecard so that will not work.
0