Total New Incidents (stats vs incidents table)

Content

Hello everyone,

I have come across one strange result in my reports and i need any set of ideas.

Results for the expression sum(stats.new_incidents) from stats table vs count(distinct incidents.ref_no) from incidents table are different.

Should it be so or it is normal and why?

 

Thank you,

Christos