2 Replies Latest reply on Dec 7, 2017 6:53 AM by Alvino Vaz

    Combining in case statement

    suvas.chandra

      I have few formulas like this:

       

      If [dim_type]="IT" Then "Investment Type" END

      If [dim_type]="VT" Then "Vehicle Type" END

      If [dim_type]="VY" Then "Vintage Year" END

       

      Case [Select a Dimension]

           When "Investment Type" Then [Investment Type]

           When "Vehicle Type" Then [Vehicle Type]

           When "Vintage Year" Then [Vintage Year]

      END

       

      [Select a Dimension] is a parameter.

       

      How can I combine them to Case statement ? Because, I can see null while controlling pie chart with the parameter.