I have a problem with my mdx expression not averaging properly for the QTD.
The QTD's are summed and not averaged. example the calcuated member
cm_HelpDeskSpeedToAnswer-P09TV for Jan Feb March all have 20 as their value
therefore the QTD average should be 20 but it is summing instead to 60.
Here is the mdx periods calculations is a shell dimension with a month level
that is hidden

avg(periodstodate([Period
Calculations].[(All)]),[Measures].[cm_HelpDeskSpeedToAnswer-P09TV])

Any suggestions or other ways of achieving the rolling year to date average
would be great.
--
JPC

What time member are you on? If you're on a quarter when you run that, it
will average the quarters, and would be 1 in the denominator, if you think
about it. It sounds like you want to average a particular way depending upon
which time member you're on. You should write your MDX to average the
children of time.currentmember, or a specific level of time.currentmember if
that's what is desired.

Good luck.

- Phil



"JPC" wrote: