How to calculate percentages correctly for totals a in view

Topic Labels: Views
978 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

+1 would love to find a better use of the group by sum