Can i add variables in expressions? if so how?

[Anonymous]

Hi Guys,

Can i add variables in expressions? if so how?

What am i doing wrong?

Sum({<PRODUCT={"xxxxxxx"},SID_MONTH={$('vMonthPreviousX12')}>}Value)

//vMonthPreviousX12

[reddy-s]

Hi Lak,

If you are using this in script try some thing like this:

let varPrev = year(today())&num(month(addmonths(today(),-1)));

load *;

SQL SELECT *

      FROM db.table

      WHERE field > '$(varPrev)';

[Anonymous]

Thanks Guys, i'll try this later on or tomorrow and let you guys know how i get on.