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 calculation and filters on metrics between multiple data tables
I am working within NSAW. I am having trouble calculating Landed Cost % of Sales. I am not seeing the numbers I would expect. I am assuming it has something to do with the filters. There is a filter for a data point from the sales table and a filter for a data point from the item receipt table. I imagine NSAW doesn't know how to apply it to only certain data points. Does anyone know how to get around this? Here is my formula.
((Debit Amount in Base Currency - Net Amount In Base Currency) / Item Quantity) / (SUM(Line Amount in Transaction Currency / SUM(Quantity Shipped))