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!
NSAW Aggregate Average in Formula
I have an average unit cost field. In order to get the data to display correctly, I need to right click the field and choose aggregate average.
I need to use this field to calculate Excess Value. My calculation is simple. Average Unit Cost * Number of Excess Units. However, the average cost value isn't correct if I just create a calculation like that. Does anyone know how to replicate the right click > aggregate(AVG) into the formula calculation? I tried AVG() but I don't get the result I am looking for.