3 Replies Latest reply: Sep 29, 2010 1:01 PM by bryankoch RSS

    Not Equal

    bryankoch

      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')