MDX syntax problem

[DictumFactum]

I have a very simple cube consisting of two dimensions and one measure. The first dimensions is an ordinary Time-dimension (Year, Month, Quarter, Day) and the second Flow_type, is a flat dimension with just three members, 1= Opening Balance, 2 = In, 3 = Out.

In the Calculated Members Builder I created a Calculated Measure with the following syntax
Iif([Flow_Type] = 0, [Measures].[Quantity], Null)

I don’t get any syntax error when I click the Check-button, but something is wrong because the Calculated Measure just returns “Err”. What’s wrong?

 

[TheHungarian]

I don't see why you chose to create such a calculated member but maybe you could try this :

=iif(flow_type.currentmember=0,measures.quantity,null)