Problem using MDX function "lif"

[ashanti]

IIf(«Logical Expression», «Numeric Expression1», «Numeric Expression2»)

Can I return string expression2 when false, because I am
getting error. How do you go around this ???

Original Code
Iif([Measures].[N]>30, (([Measures].[N]/[Measures].[Qtr N])*100), "*&quot

Thank you

 

[tlbroadbent]

The documentation indicates that the return arguments can either both be numeric or string. Apparently, data types cannot be mixed. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.