How to calculate percentages correctly for totals a in view

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?

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