Problem with round up values in pivot table

Question

Hi,

I have an excel sheet where the data in one column is rounded up by an excel formula, as example below 

(I can put maximum 1500 items in one box. Column A tells how many items I shall deliver in each shipment and col B tells how many boxes I need for the shipment.)

Col A                     Col  B =ROUNDUP(A2/1500;1)    

(items to deliver)    (Needed No of boxes)

 18 300                        13

 27 900                        19

188 400                      126

This works fine, but when I add the values from column B to a pivopt table the values change back to decimals and are no longer rounded up. Is there any way transfer the round up values to the pivot tavle?

I cant deliver 12,2 boxes so the decimal value isn't interesting to me, I need to be able to use rounded up values also in my pivot table!

Thanks in advance for any help!

/Skarvan, a confused logistics administator

Answer 1

The formula should be =ROUNDUP(C2/1500,0); this works fine in a pivot.

Regards.

Daniel