This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Custom or Column Inherited Summary Bar Fomulas

Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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.