ASO MDX Calculation not working for Quarter Members

Summary

ASO MDX Calculation not working for Quarter Members

Content

Hi All,

I am really struggling with an ASO MDX formula :

The piece of code is :

CASE

WHEN (IsLeaf([Period].CurrentMember))

THEN [Account].[Historical_Sales_Capital_Cost]/[Account].[Number_Of_Historical_VINs]

ELSE SUM([Period].CurrentMember.children,[Account].[Historical_Sales_Capital_Cost]) / SUM([Period].CurrentMember.children,[Account].[Number_Of_Historical_VINs])

END

So , the Account is "Average Capital Cost" where the formula is  = Historical Sales Cap Cost / Number of historical VINs.

As you can see in the above , at quarter level members "Average Cap Cost" value should not sum up the quarter member's children but simply calculate Historical Cap cost/Number of historical VINs at that Quarter level/Yeartotal level too.