I want to create a table to calculate my cost of goods, for products that I make.
I have a table with the list of products and their RRP.
Another table with a list of expenses, ie labour cost, packaging cost, materials cost etc
I want to have a third table that takes (product RRP) - (total costs) = profit
For example (candle $59) - (wax $2, vessel $5, packaging $3, labour $10) = $39
I’m very new to tables and formulas, so it may be easy and obvious. Any help would be appreciated!
Best answer by Databaser
Hi @Simone_Nabholz and welcome back to the community!
Are these fixed prices? If yes, you could work with a field that links to 1 or multiple expenses and then use a rollup field to make the sum. U could then do the same for your products, or, if there’s only 1 product with a fixed price, use a lookup field for the “product RRP”.
+25Hi @Simone_Nabholz and welcome back to the community!
Are these fixed prices? If yes, you could work with a field that links to 1 or multiple expenses and then use a rollup field to make the sum. U could then do the same for your products, or, if there’s only 1 product with a fixed price, use a lookup field for the “product RRP”.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.