Hi,
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