We are moving connected an Object Dependency with a VC BOM wherever we request the last effect to circular up to the nearest integer. We spot that the CEIL relation should bash precisely that but it is not working. Our look is arsenic follows:
$self.TC_BOM_QTY = CEIL ( MDATA $self.TC_BOM_QTY / TC_PC_PER_BOARD )We privation to beryllium the BOM Quantity to beryllium adjacent to the BOM Quantity divided by the fig of Pieces per Board.
For example:
TC_BOM_QTY = 45
TC_PC_PER_BOARD = 18
45 / 18 = 2.5
We are expecting the CEIL relation to acceptable TC_BOM_QTY effect to 3, but we are perpetually receiving 2.5.
We person adjacent tried the FLOOR relation to spot if its conscionable with CEIL, but we inactive get 2.5.
Is determination an contented with our Formula oregon Variables? Do they request to beryllium of a definite benignant for those functions (CEIL, FLOOR) to work?