AGGREGATE ERROR IN SCRIPT

[#1]

CLAIMS_REPORT_DEC:

LOAD

  AutoNumber(AS_OF & '|' & CLAIM_NO) AS Claims_All_Link,

   Count (DISTINCT CLAIM_NO) as Count_Claims

FROM

$(V_Layer1_QVD)\CLAIMS_REPORT.qvd

(qvd)

where Month(Date#( AS_OF,'YYYYMM')) = 'Dec'

Group by  AS_OF  ;

Attached is the error  I am getting. What am I doing wrong here?

[Gysbert_Wassenaar]

You will have to add CLAIM_NO to the group by clause as well.

[sunny_talwar]

May be this:

CLAIMS_REPORT_DEC:

LOAD

  AutoNumber(AS_OF & '|' & CLAIM_NO) AS Claims_All_Link,

   Count (DISTINCT CLAIM_NO) as Count_Claims

FROM

$(V_Layer1_QVD)\CLAIMS_REPORT.qvd

(qvd)

where Month(Date#( AS_OF,'YYYYMM')) = 'Dec'

Group By  AS_OF & '|'  & CLAIM_NO;

[dinuwanbr]

Hi,

Can you upload sample data sheet.

Rgds,

Dinu'1