Less/Greater than a variable in set analysis using

[#1]

Hi All,

I have reviewed almost every thread on this but can't get it to work.

I want to be able to use less and greater than variables in set analysis. Please see below and let me know how I can fix the variable part.

sum({<field1={'1'},field2={>"$(vVariable2)"},[field3]={<"$(vVariable3)"}>}[field4])

Thanks!!

[swuehl]

You can try to do something like

sum({<field1={'1'}>} if (field2 > $(vVariable2+1) AND field3=$(vVariable3), [field4]))

But I guess the other way should work as well.

It's probably just a matter of how your variables are defined and how the value is formatted.

So it would actually be helpful if you could show exactely how you have defined the variable and how the results look like.

Best by posting a small sample QVW.