Hi! I have a problem with aggregation and Criteria.

In my Item class I have a discount and a price. The Item class has a reference to a Collection class that also has a discount.

I want to be able to get the total price of all items and if the item has a disount ie != 0 then the price needs to be multiplied by the item disount else it should be multiplied by the collection disount.

I know I can do Projections.ProjectionList() and add a Sum projection but how can I accomplish the above aggregated function?

The query need to be done with criteria API because I have a lot of filters that is done before the Projection.

Any clues?