Group DistinctCount

[brxmas]

SQL 2000
Crystal XI

I have a group on a report {class_group_desc} I need to have a DISTINCTCOUNT for each {ad_num}

Formula {@emp}:
distinctcount({@dist})-1

Formula {@dist}
If {mc_period_dates.period_year} IN [2006] AND
{mc_period_dates.period} = 5 AND
{mc_ad_detail_view.class_group_desc} = "Employment" THEN
(
{mc_ad_detail_view.ad_num}
)

ELSE
If {mc_period_dates.period_year} IN [2006] AND
{mc_period_dates.period} = 5 AND
{mc_ad_detail_view.class_group_desc} = "Garage"
THEN
(
{mc_ad_detail_view.ad_num}
)
;

What I need to accomplish is to have a DISTINCTCOUNT for each {mc_ad_detail_view.class_group_desc}, see example:

Employment 254
Garage 397
Income 121

When I do an IF ELSE above it totals all class_group_desc
Employment 772

If anyone can help me, I would appreciate it. Thanks in advance.

 

[brxmas]

Nevermind, I can create a formula and group it by it.