Invalid expression with COUNT

[TomBond77]

Hi experts

This expression seems to be incorrect as the load script aborts with "invalid expression":

Count(DISTINCT [Order Number]) as [Count Order],

Any ideas how to fix this?

Thanks for your help

Tom

[marcus_sommer]

You need a group by statement for each field which isn't included within an aggregation.

- Marcus