Skip to Content
0
Former Member
Mar 05, 2010 at 11:39 AM

Calculate a YTD average in MDX

174 Views

Hi experts,

I'm trying to calculate a YTD average of FTE's with an MDX formula in the ACCOUNT dimension.

Is there an easy way to do this?

I'm able to calculate a 12 months AVG by using the following formula:

'sum(time.currentmember.lag(11):time.currentmember,([ACCOUNT].[A_OFFBS0600],[MEASURES].[PERIODIC]))/12

I'm now trying to insert the MONTHNUM in the time.lag() function, but that does not work.

Maybe this is not the way to calculate it and does one of you have the perfect and easy solution.

Please HELP!

With kind regards,

Robert Nijsink