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.