BEx Conversion

[Former Member]

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

[former_member184494]

tern,

In Bex once you have a formula - if it is based on another KF - you cannot use it in another formula.

Also other options you can try are :

Use a NODIM - NODIM instead of the base figures

or use a FRAC(Delivery QTY ) in order to get the remainder instead of value - floor.

Hope it helps.

Arun

[Former Member]

I've tried nodim as well... it does not work..as when I convert back to cases, the conversion always seem to happen prior to the calculation.

[Former Member]

Then u need to CHK the option in AGGREGATION..ie CALUCLATE AFTER...

Change that & try..am not sure..how far it works..

Hope this helps..

[former_member189638]

Did you try using the Mathematical Function FRAC() ?? Try with this. This should give you the decimal part of the number.

Don't use FLOOR because then obviously 0.17 will be converted to 0