Hello im having troubles with a calculation.

Im trying to calculate 68% of [Box Count]. i.e 68% of the number of boxes present in the Column "Box Count" using the following query:

No of Boxes: -Int(-[Box Count]/100*68)

The box count is 593.

68% of 593 is 403.24.

Rounded this should be 404 however when i run the query I get 414

Anyone know why this is or can give me a better solution to rounding up a percentage??

Thanks for Help!

The expression looks correct to me and testing in the Debug window gives correct return value:

?-Int(-593/100*68)
404

Check and make sure your BoxCount is 593.