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!
How to I persist the percentage calculation on the Totals row?
I am updating my Saved Search so that the totals row can still perform percentage properly.
Currently, the totals row is still blindly coming up with the SUM of the rows above it. This is incorrect and not actually practical in this context for the formula (percent) field type.
Ideally, it is supposed to be Total Qty Returned divided by Total Qty Sold.
My vague idea was to update the formula field by applying a CASE WHEN the row is identified or marked as a total, THEN perform the ideal division of the two mentioned columns.
When I made my attempt on this solution, I tried the % total function, but the numbers at the bottom is not supposed to be 100%.