2 Replies Latest reply on Jul 11, 2016 3:36 AM by Mark Fraser

    parameter and case functions

    rushendra sriram

      Hi Team,

       

      Need help in getting the below calculation correct.

       

      I have 3 measure... as M1 M2 M3.

       

      Created a parameter as M1,M2,M3

       

      Writing calculation field as

       

      case

      when parameter = 'M1' then Measure1

      when parameter = 'M2' Then Measure 2

      when parameter ='M3' Then Measure 3

      end

       

      I am getting an error. Please if required any changes.

       

      Note: when ever the user changes the parameter, the correspond  measure need to come..

       

      waiting for your response

       

      Thank you,

      Rushi