Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
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.