Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Where could the invalid expression be in this script? I'm receiving the "script error" message while running the script. The error "Error: Invalid expression" is shown in the Script Execution Progess dialog box.
SUB
Headcount_SummaryHeadCountSumm:LOAD EmpMonthYear as MonthYear,
Hi
Please remove the sub and end sub in your script..
And add DepartmentNo,workingDays, MthSrt,MthEnd in group by..
Hope that helps
I'm calling the subroutine from another tab.
Hi
Did you add
DepartmentNo,workingDays, MthSrt,MthEnd in group by..
Hi
If you use a group by statement, every field in the LOAD or SELECT must either be in an aggregate expression (like Sum or Max) or in the group by expression. As the previous post states, you have omitted some fields from the group by.
Regards
Jonathan
I was having the same problem and hadn't seen this mentioned anywhere else. This should be flagged as the the correct answer. Giving a like. Thanks for the help.