Not Equal

[#1]

I'm sure there's a really simple way to do this but I'm having a hard time finding a solution.

I'm trying to write an expression that says "count this if the [RR Code] is not equal to "Not Listed"

These are some of the ones I came up with, but either they don't work at all or they don't actually take the "Not Listed" out.

count({$<[RR Code]<>{"Not Listed"}>} [RR Code])

count({$<[RR Code]={"<>Not Listed"}>} [RR Code])

count([RR Code]<>'Not Listed')

[pover · Accepted solution]

Try count({$<[RR Code] -={"Not Listed"}>} [RR Code])

Regards.

[#3]

how about

=

sum(if([RR Code] <> 'Not Listed',1,0))

[#4]

Works like a charm. Thanks Karl.

Emma yours works great as well. 🙂