-
Dumb Question - NSAW - Calcs off columns
I am working on a dashboard that is in NSAW and i have a few calculated conditions that ive created. Now i want to create a calculation based off two different columns that are next to each other. You can do this in other tools ive worked with.…
-
NSAW using calculation/key metric formulas in pivot table
Hi, I am trying to create an easy way to see the average item sales rate. I want to take the total dollars sold / total quantity sold so I can get this average rate. I created a calculation with the following formula. SUM(Item rate * shipped quantity) / SUM(shipped quantity) When I add this into the pivot table, I assume…
-
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…
-
Forecast vs. Quota Report | Quota Calculation
Greetings NetSuite Community, I'm trying to understand the behavior of Forecast vs. Quota Report (located in Reports > Forecast > Forecast vs. Quota) this is prebuilt by NetSuite. So, let's take an example of a Sales Rep "HANNAH" whose Annual Quota for 2024 is 6,888,879.00: Now under the NetSuite Report if I Filter for…
-
Why is Total Row still showing when Show Totals = F?
Hello - I have removed the show totals from the report output, however it shows in the report output still. Please suggest how to resolve the issue.