Skip to Content
0
Former Member
Jan 16, 2008 at 08:10 AM

BEx Conversion

8 Views

Hi all,

I'm trying to do the following.

Material: XXX

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?

regards,

Edited by: J.Tern Loo on Jan 16, 2008 9:14 AM