Many thanks for your patience for such a newbie question!

I need to get a count of records where a specific field has a specific value.

I've tried a number if different ways and some of those had different field format (parens, no parens; curly brackets, no curly brackets; dbl quotes, single quotes, tics) which only confused me even more.

 

It would look something like this.

 

COUNTIF ("Survey"."Survey_was_administered_By")= "Phone"
Return 0 if no rows match

 

This is further complicated because this is an enumerated field. In this case Phone would be 0.

 

The report is running against a Remedy database if that makes a difference.

 

Any syntax help or thoughts greatly appreciated!!

 

Pete

BOXI (11.0.0.2495)