I have a landed cost template saved search. Disregard the inventory location column, the results would still be the same. Anyway, the expected value is location on hand of 95, location total value of 1,170, freight of 95 (95 x 1) and duty of 117 (1,170 x 10%). Is it possible? I guess the lines are duplicated because the landed cost details (duty and freight) are in separate lines. If I show the freight and duty on the same line, then I think that'd solve my problem. The Formula for freight is CASE WHEN cost category is Freight THEN location quantity on hand x cost factor of the cost category. The same goes for duty except that the cost category is of course duty.