How to use where clause in variable settings??

[suvechha_b]

How to write this :

=Sum({$<year1={$(vYear)}>& 'and' & $<year1={$(vMonth)}>} projectedadjustment)

in settings>>Variable Overview:

Add a variable :vData and set the above statement...

[Anonymous]

why is year1 equal $(vYear) and $(vMonth) ?

[suvechha_b]

I have to select projected adjustment depending on dimension vMonth and vYear .....

I have projected adjustment value depending on Product Code and also will depend vMonth and vYear....

[Anonymous]

try with this

Sum({$<year1={$(vYear),$(vMonth)}>} projectedadjustment)

or

Sum({$<year1={$(vYear)}, month1={$(vMonth)}>} projectedadjustment)