In my Table view I use the Totals function from the Group menu. Data is first aggregated and one of the fields is a formulae field configured in the Aggregation function as such.
All numeric fields are are summed in the Totals row, but this is incorrect for the formula field. Here the formula should work based on the total values in other fields.
Whenever you set aggregations or groupings of formula fileds, be sure to check the calculational precedence settings, either 'group values first then apply the formula', or 'apply the formula to each row value and then group the results'...the two settings can give different results.