I’m trying to make a MDX formula in a Calculated Cell for a member of a
dimension (R00090) and a measure (Budget) wish uses values from other members
(R00100 and R00130) of the same dimension in a different measure (Actual).
Can you help me with the syntax for getting the value of those cells?

Thanks,

Ricardo Vieira

Hello Ricarcdo,
this mdx calculates the store sales per store unit
along the customer dimension in the foodmart sales cube.

([Customers].[All Customers],[Measures].[Store Sales])
/
([Customers].[All Customers],[Measures].[Unit Sales])

maybe:
(
([R00100],[Budget])
+
([R00130],[Budget])
)
/
(
([R00100],[Actual])
+
([R00130],[Actual])
)


HTH
Jörg



"Ricardo Vieira" wrote:

Calculation Subcube : {[R00090]}, {[Budget]}
Calculation Value : Sum({[R00100], [R00130]},
CalculationPassValue([Actual], -1, Relative))
Calculation Pass Number : 2

Ohjoo Kwon


"Ricardo Vieira" <RicardoVieira (AT) discussions (DOT) microsoft.com> wrote