i am trying to make a formula to divide 2 field and give me a pallet count. the formula i made is {BOLRPT.OD_QTYSHIP}\{CUSTITEMUOM.QTY} . that number can come out to be anything 1.123, or 1.25, or 1.50 etc. how do i get this number to always round up to the next integer so that if its 1.12/ anything it will make it 2
Modify the code to:
Ceiling({BOLRPT.OD_QTYSHIP} / {CUSTITEMUOM.QTY});
-Abhilash
Hi Andrew,
The '\' sign will return the remainder of the division!
Modify the coder to:
{BOLRPT.OD_QTYSHIP} / {CUSTITEMUOM.QTY}
Drag and drop the formula field on the report > right-click the field > format field > use a number field without any decimals. This should round it to the next integer.
-Abhilash
thank you for this while formatting and removing any decimal fields does round the number, it round it down if its below .5 and up if its above .5.
i need the number to always round up even if it is below .5. this is a bill of lading for my warehousing company and i need it to show total pallet count on the order.
Add a check to the values if the result is below .5 then add .4 so it always rounds up.
The norm for rounding is below .5 round down and above .5 round up...
Don