Issues with measure

[MT4T]

Hi,

I have problem with Measure for calculating logistics cost.

My data model with link table seems to be correct. 

FREIGHTCOST is column with my fact value but it repeats in each row belongs to same Truck_ID

I tried to create "weight average" out of Loaded_Qty and Volume_Replaced for each row and for whole truck also for calculate % of row influence on whole truck. Then I need to apply this % result on FREIGHTCOST.

But aggregation seems to have some bugs. I check the results with copy of fact table "Loading" which is an island in datamodel.

Any ideas? 

Thanks

[Lisa_P]

I don't know your data, but I suspect you have a Key issue. What I did notice was that the Sales key was made up of DATE(date_unloading) &'|' & document_number & '|' & material ,

and your Export Key was mostly made up of DATE(Loading_Date) &'|' & "TO" & '|' & Model 

except in the Link table where is is using %Key_Loading_Date &'|' &%Key_TO & '|' & %Key_Material, not sure if they are the same.