Problem with calculating the order volume

[kubafox]

hi,

I have two tables.

The first one contains order numbers, product codes and quantities of these products. The second contains the properties of the products: weight and volume.

then adds product properties to the table with orders using "left join".

It looks like this:

left Join(orders)
LOAD
"product_id",
volume as Vol,
weight as Wei
FROM [.....qvd]
(qvd);

left Join (orders)
Load
*,
Vol*qty as vol_m3,
Wei*qty as Wei_kg
Resident orders;

 Then I create the measure:

sum(Aggr(sum(vol_m3),order_number,vol_m3,[product_id]))

the result on some lines is incorrect.:

does anyone have an idea what am i doing wrong?