I have inserted a cross tab that I would like to have show total number of specialties listed in the report. When I add the cross tab with column formula:
if {resind.class} = 'KAISER' then {service.abbr} else
if isnull({resind.class}) then " "
and
row info: count {appt.appt_id}
I get a result in my table where the specialty (column) is blank and the count is in the hundreds.
Total
Total 278
(blank) 248
Ortho 13
Oto 8
Uro 9
I do not want the blank specialty with 248 showing up when the actual results returned on the report are Ortho 13, Oto 8, and Uro 9. I am not sure what I am doing wrong. The true total should be 30.
Thank you,
Gary
if {resind.class} = 'KAISER' then {service.abbr} else
if isnull({resind.class}) then " "
and
row info: count {appt.appt_id}
I get a result in my table where the specialty (column) is blank and the count is in the hundreds.
Total
Total 278
(blank) 248
Ortho 13
Oto 8
Uro 9
I do not want the blank specialty with 248 showing up when the actual results returned on the report are Ortho 13, Oto 8, and Uro 9. I am not sure what I am doing wrong. The true total should be 30.
Thank you,
Gary