3 Replies Latest reply: Aug 1, 2016 6:32 AM by Miguel Braga RSS

    where to put variable

    naveen kumar

      Hello All,

      i have  a variable

      set vdate= 'date=,week=';

      and i have a exp:

      Num(sum(  aggr ( avg(units),Date, top,Work )) ,'#,##0')


      i want to add a varible in to this exp ,i tried over here  which is not working 

       

      Num(sum(  aggr ( avg(units),$(vdate),Date, top,Work )) ,'#,##0')


      so where should i need to put this variable so that if i select any date  it should not reflect my chart



      thanks

      naveen