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)) Debit Amount - Net Amount = The total landed costs Item Quantity is the quantity received SUM(Line Amount) / SUM(Quantity Shipped) is calculating the total sales. The filters used are dates for a time frame for the sales orders and the item receipts. I also have a filter on the sales orders for when Quantity Shipped > 0. I also have a filter on the item receipts to be Total Landed Cost > 0.