Forum Discussion

MBBIUser's avatar
MBBIUser
Regular Visitor
4 years ago
Solved

Nested IIF statement in Report Builder linked to SSAS data source

Hi,   I am trying to add a calculated member with the following logic - IIF( [Client].[Client Number] NOT IN 028193, 093386, [Client].[Client Type]=62, [Client].[Client Number] IN 028193, 093386). ...
  • MBBIUser's avatar
    MBBIUser
    4 years ago

    I found what I needed in google search. No need to respond to this post anymore. Thanks.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi MBBIUser ,

What is the logic of the calculated member and what is the final result you want? The logic is to combine client number and type 62 if the client number is not 028193 and 09338, otherwise, the original client number (028193 and 09338) is displayed? If you have the following table data, what is the final result you want to display?

In addition, you can refer the following links to get it.

Decision Functions

Writing Complex Expressions

Best Regards

MBBIUser's avatar
MBBIUser
Regular Visitor
4 years ago

I need client number returned. For the example you have here, I will need 028193, 093386, and 093387 with 028134. I need two values (client numbers returned).

 

Would you happen to know if there is "OR" function in there that I could use instead?

 

Thank you!