Calculated Member Values When Drilled Down...

[rheilman]

I have a dimension called Calendar with the following levels...

Year, Month, WeekEnding, and Date

While searching, I found a helpful response from MDXer to get the following syntax...

IIF(ISNULL([Calendar].PrevMember), 0
, ([Calendar].CurrentMember, [Measures].[Std Hours]
- ([Calendar].PrevMember, [Measures].[Std Hours]))

...to produce a calculated member to show the change from the previous value. This appears to yield a proper number at the top (Year) level of the dimension, but calculated member values go away when I drill down to the remaining lower levels of this dimension.

I'm new to this. Any ideas?

Thanks!
Ray <><

"I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh

 

[rheilman]

Upon closer examination, I am getting values at all levels.

Sorry to have bothered you.
But thanks MDXer for the syntax help from Thread960-737611!

Ray <><

"I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh