Query calculations

[patheo]

Hello,

I am trying to launch three different queries that are suppose to return the same result in there respective reports for the same period but it fails to match.
The firts reports sales per article and the second reports sales per family from the same article bases.
Could you help me set the relationship joins?

See attached the DB.

Thank you in advance.

Pathéo

 

[Galaxiom]

I have not looked at the database but your description suggests you have a denormalised data structure. You are storing values that are derived from the same underlying data.

All your report calculations should come from the same transaction data. Then there should be no problem with conflicting outcomes.