I'm trying to do the following.
Delivery Quantity in CV: 100 CV
Conversion factor: CV -> PAL = 1 -> 24
After conversion to PAL (using Conversion in BEx)
Delivery Quantity in PAL = 100 / 24 = 4.17 PAL
Floor (Delivery Quantity in PAL) = 4
I'm trying to get the remainder of 0.17 and convert it back to CV which is 0.17 * 24.
However when I try to convert 0.17 back to CV. Formula = Delivery Quantity in PAL - Floor (Delivery Quantity in PAL) + Conversion to CV
I always get 0 when I'm intending to get 4 ((4.17-4)*24]), apparently the conversion always happens at the data level ignoring the calculation.
Any idea how could we go about this?
Edited by: J.Tern Loo on Jan 16, 2008 9:14 AM