Hello Everyone,

I need some assistance on the below.

Im using a table(Tab1) with 2 million records. Im looking for Purchasing Document Number (EBELN) which has more than 1 entry and i need the count of Unique Document Numbers and the count of Documents having more than 1 entry.

Im using the below Case statement

CASE WHEN COUNT (DISTINCT Tab1. EBELN) > 1 THEN 1.0 ELSE 0.0 END

this gives me 1 if the record is unique and 0 if not unique.

I need the total count of uniques & non uniques. When i try the below im getting an error saying Aggregate expressions cannot be nested.

SUM ( CASE WHEN COUNT (DISTINCT Tab1. EBELN) > 1 THEN 1.0 ELSE 0.0 END )

Appreciate the assistance.

Thanks!!

Regards,

Chanti