Set Analysis and More Filters

[#1]

Hi all,

I've got a sample set analysis expression like the below:

avg ( {$<Hourly_Rate_Date = {*2014*}>} Hourly_Rate )

The above, effectively, says "display hourly rates when the date is in the time span of 2014" (our date data is poorly formatted so using the wildcard with 2014 works best right now).

However, I'm confused - if I want to build on this expression to say...

"display hourly rates when the date is in 2014 AND only positive values"

(positive values is great, but in general, the logic I'm trying to learn about is how to add an 'AND' to this type of expression. I tried adding ">0" to the end of the expression but that did not work. Any help is greatly appreciated. Thanks

[#2 · Accepted solution]

I figured it out all:

=Avg({$<Hourly_Rate_Date={"*$(=2014)*"},Hourly_Rate={">=0"}>}Hourly_Rate)