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

[Former Member]

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

[Former Member]

Hi,

You will have to use Sub query to achieve this. Give more details on what is available and what you need then i could help you out with the complete solution.

Thanks,

Ravichandra K