Addition in script

[TomBond77]

Hi experts

I am getting the error message "invalid expression". I don't see any issue. Can you please help? Many thanks.

[Fact_temp20]:
Load
*,
(Sum([Actual Cost]) + Sum([Additional Costs])) as [Total ]
Resident [Fact_temp10];
Drop Table [Fact_temp10];

[Frank_Hartmann]

aggregations like "sum" requires a "group by" in Load statement!

[TomBond77]

Thanks Frank, which fields must be part of the group by statement? All fields of the first table?

[Frank_Hartmann · Accepted solution]

all fields which are not used by an aggregation.