Skip to Content
May 28, 2018 at 12:40 PM

Total of column values <> calculated total



I have a table with project numbers as rows, there is a certain column that does the following calculation :

(Current budget - First budget) * % of completion.. (these columns are available in the table)

This works fine on the row level but when I get to the total at the bottom of the table... I want the total to be the sum of the calculated values above, and instead he calculates the (total current budget - total first budget) * total % of completion.

Which of course is wrong by calculating % like that. Is there a way to just take the sum of the above instead of recalculating it as a total value without project dimensions?

thanks in advance