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.


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


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



      I cannot get it to work unfortunately, please help.