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!
Using % Formula of Summary level
I'm trying to calculate the waste percentage of a certain group of items. For waste, I'm basically just comparing the total qty purchased, to the current available qty.
I'm using an item search, setting the criteria to Trans Type=PO, then summing the Trans Qty. Also including the available field, and grouping by item. This part works well.
I'd like to add a Waste % column. I'm able to create the column using Formula(Percent)- {quantityavailable}/{transaction.quantity}. This works perfectly on the drill down screen, but I need to bring it to the summary level. The % is only useful if I'm using the sum of the trans qty. I'm just not sure how to accomplish this.