Comparing sales to budget

We recently switched from using spreadsheets to Airtable to track advertising sales, and I am quickly learning how Airtable does not have some of the basic abilities of a spreadsheet. In our old spreadsheet way of doing things, we were easily able to total up advertising sales in a field and compare it to an entry containing the budget goal for advertising sales. I cannot figure out how to do that in airtable. The attached image shows what I am trying to accomplish. I have been able to create a summary field in our table that ads up the total sales, but I cannot figure out how to create the budget line and % of budget reached line / formulas. Any help is appreciated!

airtable example

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.