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!
Need Help with Saved Search Formula
I created two custom formulas ("actual sell price" and "actual profit"). I also have the "actual profit%" custom formula created. All 3 columns are working correctly.
Need: Divide sum of "Actual Profit" / sum of "Actual Sell Price". [Screenshot: 28,499,575/90,729,670]
I do not need this for each row, just 1 line at the bottom of the saved search. Is this possible?
I tried SUM (actual sell price custom formula)/SUM (actual profit custom formula); also tried SUM/COUNT.
Thank you in advance and Happy New Year.