Jul 10, 2007 at 09:17 AM

# Getting Unit Price from Net Price by dividing with Quantity.

855 Views

Good Day Guys,

I have a requirement, wherein I've got to find the Unit Price Per Item, by Dividing Net Price with the Quantity.

Currently, Quantity field (MENGE) is of type QUAN.

Let me tell you what I experience when i divide by type QUAN:

I have Net Value : 87405.32

I have Quantity Value : 2.000 (Data Type - QUAN)

When I divide ( 87405.32 / 2.000 ), I see that I am getting, a value which is 43.72.

( It should acutally be, 43702.66 ).

So, On seeing the value 47.02, I multiply by 1000 and I now get the value 43700.00

Now, I see the Decimals, the Units, and the Tenths, are all replaced by zeroes, by doing so. This still is a problem, cause I don't get the exact value of 43702.66

I guess, I need to find a function module that will change this quantity of 2 which of type QUAN to Integer, in order to get the exact value.

Would it be possible for any of you, to give me a suggestion as to what i can do, to obtain the exact value, and if there is any function module that will convert QUAN type to Integer.