Skip to Content
0
Feb 13, 2015 at 09:15 PM

Count of Field Question

15 Views

Hello brothers and sisters,

Looking to count different exams that are within the same field.

Field = {Exam 1}

Different exams within {Exam 1} include MRI, CT, EMG/NCS. I'm trying to count each of these. So far I have these formulas, but they're not yielding the correct results:

MRI

If {Exam 1} = 'MRI' then

Count ({Exam 1})

CT

If {Exam 1} = 'CT' then

Count {Exam 1})

EMC/NCS

If {Exam 1} = 'EMG and NCS' then

Count ({Exam 1}

Thanks!

Rich