Table Total Values Not Calculating Correctly

[mroo11]

Is there a way to have totals not aggregate by sum or average. Screenshot shows the percent change from 2 columns trying to be calculated but total percent change being calculated as the sum of values instead of the calculation.

[David_Wong]

Hi @mroo11,

Instead of calculating the percentage as sum(({Final Value} - {Initial Value})/{Initial Value}), try sum({Final Value} - {Initial Value})/sum({Initial Value}).