I’m using bases to create several budgets to manage lead source, subdivided into categories. When I group my lead sources by category, I want to be able to run the same calculations I do on each individual entry.
I have basic formulas in several columns.
ROI - Sales/Spend
Cost Per Lead - Spend/Leads
Conv % Jobs/Leads
I’d like the summary bar for each group to run those calculations too. Thus, if I have 50 lead sources in the radio grouping, my summary bar would take the sum of all the sales for the 50 entries and divide it by the sum of the spend for the same.