Count where Value in a Field not equal to

[alec1982]

Hi i have the following Expression:

Count({$<[YearDate] = {2012}>}[Location])

How can I make the same expression where the YearDate NOT equal to 2012.

I tried

Count({$<[YearDate] <> {2012}>}[Location]) but it is giving me error.

Thanks,

[bgerchikov · Accepted solution]

Alec,

Try -=

Count({$<[YearDate] -= {2012}>}[Location])

[alec1982]

I am still getting a little red line under it? would that mean it is wrong?

[bgerchikov]

No, it doesn't. Sometimes QV shows red even though there is no error. Just try it  out.