Hello,

My name is Swadi. I have just started implementing coherence in one of the POC.

I have gone through some parts of coherence but did not find a solution for that.

Have some idea about GroupAggregator, EntryAggregator, ValueExtractor , ReflectionExtractor but that does not really solve the purpose.

e.g

Suppose there is a table with multiple columns, couple of them are "Price" and "Quantity". I need to calculate "Average price" of it.

In SQL query I used to write

Select product,customer, sum(price*qty)/sum(qty) as avgprice from order

group by product,customer

I need to write same logic in Coherence. Please help me.