Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
Try count({$<[RR Code] -={"Not Listed"}>} [RR Code])
Regards.
how about
=
sum(if([RR Code] <> 'Not Listed',1,0))
Works like a charm. Thanks Karl.
Emma yours works great as well. 🙂