Skip to Content
0
Former Member
Jun 08, 2009 at 01:04 PM

How to Perform an Aggregate Function?

88 Views

Hi,

I'm trying to define in Designer 6.5 an object with the following select: (example)

sum (count (distinct REPORTING.table.object_name))

the SQL parsing restitues me this error --> "The SQL can not perform an aggregate function on an expression containing an aggregate or a subquery".

Can anyboby explain me the problem and above all how to solve it?

Thanks

Riccardo