topic Re: Rounding for Analytical Data in Application Development and Automation Discussions

Rounding for Analytical Data

Former Member — Mon, 27 Jul 2009 14:50:01 GMT

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.

Re: Rounding for Analytical Data

former_member194669 — Mon, 27 Jul 2009 15:33:47 GMT

Whether CEIL will work ?

Check this

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

a®

Re: Rounding for Analytical Data

Former Member — Mon, 27 Jul 2009 15:44:15 GMT

Try to use FIMA_NUMERICAL_VALUE_ROUND

Max

Re: Rounding for Analytical Data

Former Member — Mon, 27 Jul 2009 18:06:42 GMT

FIMA_NUMERICAL_VALUE_ROUND does not seem to handle analytical rounding rules

Re: Rounding for Analytical Data

Former Member — Mon, 27 Jul 2009 18:42:44 GMT

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