Skip to Content
0
Former Member
Dec 01, 2011 at 08:50 AM

Can't have aggregate function in WHERE clause <clause>

36 Views

Dear all,

I've created object in BO XI 3.1 Designer with following criterias:

http://img4.imageshack.us/img4/833/20111201124314.th.jpg

It is a simple number - 1,2,3,4,5.

Now I need to use this object as a criteria for WHERE function in another object.

http://img607.imageshack.us/img607/1543/20111201124717.th.jpg

I receive an error "Can't have aggregate function in WHERE clause <clause>"

How can I overcome this?

P.S. I'm sorry in advance if such topic already exist - I didn't found one.

Edited by: Ashot Antonyan on Dec 1, 2011 9:50 AM

Edited by: Ashot Antonyan on Dec 1, 2011 9:51 AM