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!
creating an accurate aggregate percentage function
Good afternoon,
In Netsuite, we created a custom column for estimated cost in opportunities, we don't utilize items because for every deal cost changes, In a search I can use sum to total up the amount, costs, as well as gross profit, I can't get a function to do gross margin, if I do est. cost / amount it will total up the margin for each line (like if one line was 10% and another was 12% search would result in 22%) Need to create a function that takes sums of quantities in multiple lines and divides by sum of quantities in