0 Replies Latest reply: Jun 22, 2016 12:37 PM by Syed Jamal RSS

    How to store values in Variable

    Syed Jamal

      Hi All,

      I am trying to create a Variable but could not get what Iam supposed to. Actually, I want to save sum value in the variable in order to use in calculation.

       

      Variable:

      vTest = sum(if(COMPANYGROUPNAME = 'Industry',YEAR2_MARKET,0));

      where YEAR2_MARKET is Decimal value. E.g 1400.00

       

      If vTest = 1400; I would like to use 1400 in my Measure expression like below measure expression

       

      sum(YEAR2_MARKETPER))/$(vTest)

       

      Result:

      Getting 0 values. What I am doing wrong above. I also put same varaible on Data load editor as well but no help.

       

      Please help me how do I store some value in Variable so I can call other places.

       

      Thanks.