If I remove the number formatting on the pivot plugin the total is still wrong however if i remove the number formating on the summed elements, the total is correct!If you turn off number formatting everywhere, so it's just plain old dotted decimal with no thousand sepchars, does it total correctly?