Report is not showing correct data

Content

Hi Everyone,

i am facing an issue in reports.

i am using 2 joins in reports, contact -> incidents and contact-> products( this is custom object and 1:M relation).

in my report, i want to show # of open incidents and # of products associated to contact record.

for open incidents, sum(if(incidents.status_id="Solved,0,1)) expression and getting correct data

for product count: count(CO$ContactProduct.ID) expression and getting wrong data

Can you please help on this.

Thanks

Prasad