Creating Formulas Across Multiple Records In Same Base


I am looking to create profit margin and profit margin formulas on a multi-record base that I am using for inventory management. The manufacturing cost is on one page, purchase orders on another page and sales orders are on the final page. I’m looking to create something to show those profit margins and $ on the sales order page to show how each product we carry stacks up against each other.