Please find below the MDX formula assigned to account A1040. The result is for Actual, Current and Standard always error

However when ik assign this MDX statement to a new calculated member the proper values appear. I think the problem is the original value at A1040. For instance Actual A1040 is equal to 999 from the datawarehouse. The formula will re-assign A1040 according to the formula

It seems that if a formula is assigned, the formula is prevelant to the original value. Does anybody know how to solve this

Iif([Measures].CurrentMember is [Actual]
([Measures].[Actual], [Account].&[A1040])
Iif([Measures].CurrentMember is [Current]
([Measures].[Actual], [Account].&[A1040])
Iif([Measures].CurrentMember is [Standard]
([Measures].[Standard], [Account].&[A1040])





(I know that this statement could be abbreviated easily, but this example looks more clear to explain)

It's an infinite recursion problem. You're asking for a value that depends
on itself. The calculationpassvalue function might help you out to remove
the infinite recursion. ANd you can simplify this a bit. Try this:

Iif([Measures].CurrentMember is [Measures].[Actual] or
[Measures].CurrentMember is [Measures].[Current],
calculationPassValue(measures.actual,-1,relative),
calculationPassValue(measures.standard,-1,relative)
)

Be cautious with calculationpassvalue function. Most of the time everything
is just fine, but if you're doing funny things with passes it might not give
you the results you expect.

Hope this helps,
Richard
--
This posting is provided 'AS IS' with no warranties, and confers no rights.

"J. Nathalia" <anonymous (AT) discussions (DOT) microsoft.com> wrote

For instance Actual A1040 is equal to 999 from the datawarehouse. The
formula will re-assign A1040 according to the formula.