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
Solved
Subtracting Values of 1 Rollup Column from Another
Best answer by JonathanBowen
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
+18Hi @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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.