Hi
Can you please elaborate further on how you access the “total row” formula.
I tried adding the formula to my existing calculated measure but I keep getting errors. How would i add it to this formula to ensure the total row only calculates the values displayed in the report:
Case when [Measures].[Duration of Task (Week)]>=1 then
([Measures].[Original estimated hours with target end]/
[Measures].[Duration of Task (Week)]) ELSE
[Measures].[Original estimated hours with target end]
END
Duration of task (week) is a calculated formula based on the days between target start and target end