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!