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.



      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





      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.