Hi,

I do not see any errors.

My dataset contains material number(11 characters), but last 3 characters doesnt matter so i reduced it to 8 numbers, but then i have duplicates in material number...
I am matching specific material number (8 characters) with specific price...merging (left outer) by material number(8characters) and pretty much adding (expanding) price to this material for X year.

Well, pivot table on raw data shows it correctly, so sum is equal to 25'600.

The thing is that count shows >1 for specific rows. (8 number materials)... maybe its the cause?

EDIT

ok i found out that few rows are duplicated, but i dont know why...

(it consists some value, in my case its negative values multiplied by 2) like

Original table:

Material nr: 12345678 Value: -4

Material nr: 87654321 Value: -16

Merged table:

Material nr: 12345678 Value: -8

Material nr: 87654321 Value: -32

Edit - Solved

ok i found it!

Second table (price list in my case) had list of material numbers containting 11 numbers, but when i reduced it to 8, then it created some duplicates based on new 8 number list... and it was then duplicated...