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?
How to calculate percentages correctly for totals a in view
+18+1 would love to find a better use of the group by sum
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.