"Script Error", why?

[wgonzalez]

Hi,

I want to summarize transactions in a resident table, but I'm getting the "Script Error" message and can't identify the cause.  Could someone help?  See the script below.

Thanks.

/* Summarized Attendance Data */

AttTemp:
LOAD DTPunchDate as PunchDate,
ParentTrans as ParentT,
AttCategory as AttCat,
AttHours as AttH,
Date(monthstart(DTPunchDate), 'MMM-YYYY') AS
MonthYear
Resident AttTrans
Order By DTPunchDate asc;

/* Summarizes Attendance Transactions. Used for charts showing annual info per month. */
AttSumm:
LOAD MonthYear,
ParentT as ParentTr,
AttCat as AttCateg,
sum(AttH) as AttHoursSumm
Resident AttTemp
Group By MonthYear, ParentT;
//Order By MonthYear, ParentT asc;

//DROP Table AttTemp;

[swuehl · Accepted solution]

You need to either add AttCat to your group by field list or use an aggregation function with AttCat:

No other fields than the aggregation fields may be used outside aggregation functions in the loaded expressions.

[wgonzalez]

Thanks!  It worked!