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?