Merge tables following Group by (Max) values change error?

[jilbobagins]

Hi,

strange one! Following a tables grouping (by item) and including the Max Value (against a decimal value qty in this case) I then merge to another table with matching items and the Max value from the first table changes !!??

very odd and has got me a little confused

any ideas ?

 

[pinarello]

As a workaround you have to insert an index before the merge, or enclose the merge in a Table.Buffer. This will cause the data to be reloaded internally.

 

[jilbobagins]

I will give that a go! Many thanks for responding so quickly ��

Great experts on this site !