Checked the 0  average cost of Per Location Sales Report then modified the query and added the condition case when b.set_code in ("M","1") then b.current_cost else b.avg_cost end then processed the report and validate