Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to calculate percentages correctly for totals a in view

Topic Labels: Views
365 0
Showing results for 
Search instead for 
Did you mean: 

How can percentages be correctly calculated in the grid subtotals for groups, and totals for the entire view, when detail records are grouped and summed? It is not correct to average the percentages calculated on individual records. For example, see the attached image. The correct percentage gain is $500,000/$1,100,000 = 45%, not (50%+0%)/2=25%
There should to be a formula calculated using the total of the two columns. Is this possible with AirTable?
Screenshot 2022-01-28 094755

0 Replies 0