Count of Field Question

[former_member406941]

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

[abhilash_kumar · Accepted solution]

Hi Rich,

Try this please:

1) Create a formula @MRI with this code:

If {Exam 1} = 'MRI' then

1

2) Go to Insert > Summary > choose this formula field as the Field to Summarize > Choose the Summary Operation as 'Sum' > Choose the right summary location.

On the same lines, create the other formulas and insert summaries against each of them.

-Abhilash