topic Re: resident load invalid expression in App Development

resident load invalid expression

drohm002 — Tue, 04 Nov 2025 17:36:54 GMT

Hello, can anyone tell me why I am getting an "invalid expression" error when i load the script below?

Re: resident load invalid expression

dncontin — Tue, 04 Nov 2025 18:31:47 GMT

try

GROUP BY
[Report Finalized By],
[Finalized Date];

Re: resident load invalid expression

Amit_Prajapati — Wed, 05 Nov 2025 04:49:50 GMT

Hi @drohm002 ,

You're performing an aggregation operation using COUNT(Internal Exam Id).

As per @dncontin guidance, when applying any aggregation, all remaining dimension fields must be included in the GROUP BY clause. In this case, please ensure the following fields are grouped:

[Report Finalized By], [Finalized Date].