4 Replies Latest reply: Aug 20, 2014 9:48 AM by A Lee RSS

    Using string munipulation in Expression

      Hello, new user here that would benefit from experts from this forum.

       

      I have a string variable:

      vCurrentQuarter = 'Q2'

       

      In my expression, I would like to perform a simple calculation.

      For 'Q2', I would like my result to be 'Q1' (i.e. 2-1)

       

      This calculated string of 'Q1' will then be used to pull a value from the cube.

      CurrentQuarter.Q1.CV

      =sum(={'CurrentQuarter.Q' & (Right('$(vCurrentQuarter)',1)-1) & '.CV'})

       

      So in essence, I would like my derived line to be:

      =sum(CurrentQuarter.Q1.CV)

       

      I cannot get it to work unfortunately, please help.