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...

[orital81]

You wrote $<year1={$(vYear)}

      and' & $<year1={$(vMonth)}

This will not bring you data... Please write in psaudo code what exactly did you mean?

Did you mean this? year1=vYear and month1=vMonth ?

If so then try this:

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