Subtracting Values of 1 Rollup Column from Another

[Alex_Wallon]

Hello, I have a question.
I have a table for sales and inventory. I’m creating kind of a master page that keeps track of number by each month. I have columns that Rollup the ‘Amount Spent’ and the ‘Amount Made’. I’m just trying to create another Rollup column that calculates the Profit/Loss by subtracting the total amount spent from the amount made. Is this possible? Each row has data for a specific month. Hopefully i’m explaining it correctly! Thanks in advance

[JonathanBowen · Accepted solution]

Hi @Alex_Wallon - you don’t have to make another roll-up field for the profit, you can just have a formula field that takes one from the other, e.g.:

{Sales Revenue} - Costs

JB