Formulas within a pivot table
 

I currently hav a pivot table set up where the data is the sum of a specific
operation, per week, against specific machines.

What I am wanting to do is divide this data by that machines run rate.

On some instances the formula calculates correctly on others it seem to be
dividing the figure by 2?

As anyone else had this problem, and if so how can I resolve it