Invalid expression

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Invalid expression

Aurelien_Martinez — Wed, 18 Oct 2017 13:54:29 GMT

Hi,

Add [Complaint Registered Date] to your group by

Aurélien