Pivot Table Strange Numbers

Hi All

Me again! lol ... sorry, but I'm pulling my hair out with this pivot table hopefully one of you can help me!

See attached. If you look on the pivot tab, at the section beginning at row 21, you can see it shows, "##########" and the numbers are incredibly high in column G and H - if I look at the raw data I can see nothing there that would throw up these kind of figures (basically, compare it to the section starting at 9 - this is what it should be more like)

It seems to be completely random :/

Any help would be really appreciated

Thanks!x

You appear to be multiplying dates together which would account for the big numbers.
I would suggest that in the value field settings that you use a function such as max rather than product.