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!
Calculation on Totals
Hello,
This is likely a dumb question but is there a way to do calculations/formulas on totals on saved searches?
For example, my search looks at transactions for a month. I get sell price and cost for every line item sold that month. I total these columns and then want to calculate profit margin on those sums.
I can calculate profit margin for each line but there is no accurate way to show the margin for the summary (average, sum etc. are all inaccurate for the total).
Thanks all.