topic Re: Function to format numbers in Application Development and Automation Discussions

Function to format numbers

Former Member — Wed, 06 Dec 2006 18:34:22 GMT

Hello,

I am trying to write a function that does the following 2 things:

If a number is an integer, first add .00 after the integer, then add zeros in front such that altoghther it makes 9 characters (e.g.: 12 -> 000012.00)

If a number is not an integer, then ensure it is 2 decimals by truncating whatever that is after the 2 decimals and add 0 in fron as well (e.g. 12.12345 -> 000012.12)

There would be no number larger than 6 digits (i.e., 9 characters altogether)

Does anyone know whether there is any existing function or method that would do the job or at least part of it?

Thanks!

Regards,

Anyi

Re: Function to format numbers

ferry_lianto — Wed, 06 Dec 2006 18:39:08 GMT

Hi,

Please check FM HR_NL_ROUNDING.

Regards,

Ferry Lianto

Re: Function to format numbers

Former Member — Wed, 06 Dec 2006 18:45:53 GMT

Hello,

So now the rounding and 2 decimal bit is resolved, anyone has any suggestion regarding the adding zero part?

Thanks Ferry for the suggestion!

Regards,

Anyi

> Hi,

> Please check FM HR_NL_ROUNDING.

> Regards,

> Ferry Lianto

Re: Function to format numbers

raja_thangamani — Wed, 06 Dec 2006 18:49:56 GMT

use Function module "ROUND"

Raja T

Message was edited by:

Raja T

Re: Function to format numbers

ferry_lianto — Wed, 06 Dec 2006 18:52:40 GMT

Hi Anyi,

This FM will do rounding into 2 decimals then you need to fill zeros.

Regards,

Ferry Lianto

Re: Function to format numbers

Former Member — Wed, 06 Dec 2006 18:59:51 GMT

Err...I am more concerned with the 0s in front now...

Thanks anyways!

Anyi

> use Function module "ROUND"

> Raja T

> Message was edited by:

> Raja T

Re: Function to format numbers

ferry_lianto — Wed, 06 Dec 2006 19:05:40 GMT

Hi Anyi,

Please try this.

DATA: NUM       TYPE P05_DEC15_4,
      ROUND     TYPE  MAXBT,
      RESULT(10) TYPE C.
                                                                        
MOVE '12.12345' TO NUM.
                                                                        
CALL FUNCTION 'HR_NL_ROUNDING'
  EXPORTING
    INPUT  = NUM
    METHOD = '1'
  IMPORTING
    OUTPUT = ROUND.
                                                                        
MOVE ROUND TO RESULT.
SHIFT RESULT RIGHT.
TRANSLATE RESULT USING ' 0'.
WRITE: / RESULT.

Regards,

Ferry Lianto