I have a wall product that is made in 4' wide increments. The product
is sold by the foot. A customer may order 38 feet but they will
actually receive 4 sections for a total of 40 feet. (they would then
field cut it to fit....)
In order to provide a shipping quote, I have to calculate a weight.
The weight table for this item lists a weight per 4' section. So what
I was trying to do was divide the order qty by a UOM_factor which in
this case is 4 and then multiplying that times the 4' section weight.
This works but only if the ordered qty is actually in a multiple of 4.
i.e.
item weight per 4 ft: 10 lbs
order qty = 80 feet
uom_factor= 4
80 / uom_factor = 20
20 * 10lbs = 200lbs WORKS OK !
order qty = 77 feet
77 / uom_factor = 19.25
19.25 * 10 = 192.50lbs NO GOOD because even though they
only "ordered" 77 feet they would receive 80 feet.
How can I make it round "up" to the nearest increment of 4 in order to
capture the "true" shipping weight?
Thanks for any suggestions....