Invalid Expression: Date Field in resident load

[helen_pip]

Hello

Could someone kindly tell me why I am getting an invalid expression by adding in the MonthYear into a resident table?

I get this error every time I add in a date field into my resident table

Invalid expression

ED_Patients1:

LOAD

Median([Total Wait])/1440 as Total_Wait_Median,

Fractile([Total Wait],0.95)/1440 as Total_Wait_Fractile,

Median([Triage])/1440 as Triaged,

MonthYear

RESIDENT ED_Patients

Does anyone have any ideas?

Thanks

Helen

[#2 · Accepted solution]

Hi,

You can try adding a Group by Function after your Resident load

ED_Patients1:

LOAD

Median([Total Wait])/1440 as Total_Wait_Median,

Fractile([Total Wait],0.95)/1440 as Total_Wait_Fractile,

Median([Triage])/1440 as Triaged,

MonthYear

RESIDENT ED_Patients

group by MonthYear;

Regards,

Alex

[helen_pip]

Thank you!  Works a treat