you can use this as a group select option but not a record select and exclude an entire group based on the group summary result.

Edited by DBlank - 07 Nov 2013 at 4:04am

I would like to re-state the question since it may not have been clear. In the Select Expert you can do this:

   myfield <> 99

This is very simple, if myfield is equal to 99 the record will be left out. That is all, I want to do but only if a separate expression that counts values returns one (1), If it returns two (2) or more I want to do something else. So, can you do something like

If CFR_CNT = 1
then
       myfield <> 99
else
       someotherthing.

another way to say what DBlank is saying...
you need to read all the rows in the data to determine if the formula result is true or false...BUT you want to exclude records based on the formula (which cannot be evaluated until all records have been read into the report)

you are in a catch-22

DBlank correct me if I am wrong

Sorry, but the use of if-then example was not meant as a way of implementing the requirement but just to explain it. Now, I will be more specific as you requested.
I use the Formula Field below to determine how many worker were involved on a job.

 DistinctCount ({MeterSessionOutput.WokerID},{WorkSet.WorkSetID})

The above expression will return 1 or more representing the number of workers for a given work set. It was discovered that certain types of records should be filtered out depending on the number  of workers involved. So, if the above expression evaluates to one (1), I want the following filter in the Crystal select expert:

                        myfield <> 99

Now, the question is how to implement it.