Hi,
I am trying to run a report on number of patients who had their BMI checked during last month. (250 patients was seen) how many of them had their BMI checked and how many didn't. When I add the first field which is the patient ID it returns 250 patients but when I add the BMI field the patient ID count changes to 175, I would like to see the 250 patient ID with and without the BMI%
what am I doing wrong?
I am pulling the data from three different Excel cheets. and I'm using Crystal X1

Here is what I would like my report to look like:
Patient ID:   BMI%
2222222        25.02
3333333        32.00
4444444
5555555        40.00
But here is what I'm getting:
Patient ID:   BMI%
2222222        25.02
3333333        32.00
5555555        40.00
Thanks for your help.