Hello all,

I have a strange situation...

I have the following MDX-syntax:

IIF(([View].[Period Values] <> NULL),
IIF(LEFT([Measures].CurrentMember.Name,6) = "Budget"
-- value #1 --
,1
-- value #2 --
,0
)
,NULL)

In the result, when Measures = Budget, the result = 2 (2 times value
#1), and when Measures <> Budget, the result = 0 (good).

When I leave the first iff-statement away:

IIF(LEFT([Measures].CurrentMember.Name,6) = "Budget"
-- value #1 --
,1
-- value #2 --
,0
)

In the result, when Measures = Budget, the result = 4 (4 times value
#1).

What do I do wrong? I just want 1 (value #1) as result.

Thanks for any help.

Marco.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!