How to use where clause in variable settings??

suvechha_b — Mon, 22 Jul 2013 19:46:12 GMT

How to write this :

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

in settings>>Variable Overview:

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

Re: How to use where clause in variable settings??

orital81 — Tue, 23 Jul 2013 13:49:37 GMT

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)