Hi All,

I'm trying to figure out how to approach a calculated member with an MDX expression. Here's what I want to do.

I have some existing calculated members (measures) figure out a rate represented as percentage. The problem is that the users think about these rates at their annual level (one of the inputs to this calc is semi additive). What I need to be able to do is
scale them up to be indicative of the annual rate.

So what I have now is this

Year: 1.17%

Quarter: 0.29%

Month: 0.10%

I need to scale these up as follows:

Year: 1.17%

Quarter: 1.16% (0.29*4 quarters)

Month: 1.20% (0.1*12 months)

Can anyone demonstrate how to alter the multiplying factor at different levels of a time dimension?

Thanks in advance,

Mark