Invalid expression

[bobbydave]

Can anyone see where my issue lies?

Concatenate(Weekly_Validations)

Load

  Complaints_Country_Code as [Country Code],

  text(ApplyMap('MapDateToFiscalWeek', replace(WeekName([Complaint Registered Date]), '/', '-'))) as Fiscal_Year_Week,

  [Complaint Registered Date],

  null() as [Weekly_Date],

  'Complaints Registered' as Weekly_Control,

  sum([Case ID]) as [Weekly Record Count]

FROM

[$(vQVDs)\A_Complaint.qvd]

(qvd)

where exists([Fiscal_Year_Week],  text(ApplyMap('MapDateToFiscalWeek', replace(WeekName([Complaint Registered Date]), '/', '-'))))

group by text(ApplyMap('MapDateToFiscalWeek', replace(WeekName([Complaint Registered Date]), '/', '-'))), Complaints_Country_Code

;

I keep getting Invalid Expression

[Aurelien_Martinez · Accepted solution]

Hi,

Add [Complaint Registered Date] to your group by

Aurélien