Rounding for Analytical Data

[Former Member]

Is there a function module that does Rounding for Analytical Data?

If I use function module ROUND, 1.25 becomes 1.3 and 1.35 becomes 1.4

But in analytical rounding rules, if the last digit is even round down and last digit is odd round up. So 1.25 becomes 1.2 and 1.35 becomes 1.4.

[former_member194669]

Whether CEIL will work ?

Check this

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3316358411d1829f0000e829fbfe/content.htm

a®

[Former Member]

Hi

Try to use FIMA_NUMERICAL_VALUE_ROUND

Max

[Former Member]

FIMA_NUMERICAL_VALUE_ROUND does not seem to handle analytical rounding rules

[Former Member]

megan,

do one thing.

check the last digit of the number(dec_digit in the code snipet). (1st digit after decimal as per your rule). u can pass it to string and then use split or some other thing to get the 1st digit after decimal.

then use a if block either to floor or ceil.

gv_val = dec_digit mod 2.

if gv_val = 0.
   gv_result = floor (amount).

else.
   gv_result = ceil (amount)

endif.

i am not givign a executed code here as i dont have sap currently with me. but use this logic. hope this will do your job.

thanks

Somu