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), "*")
Thank you
I am a beginner in using OLAP, so please forgive my simple question.
I have data made up of one dimension and one measure.
City number
---- ------
Atlanta 1
Macon 0
Macon 1
Atlanta 1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.