Skip to Content
avatar image
Former Member

How to delete trailing zeros after the decimal point in the ALV sum

Hello Expert,

In my alv output, I need to sum up one column, but in the sum result, I don't want to display zeros after the decimal point.

for example,

If the sum is 134.00, I only want to display 134 on the alv.

Does any expert have idea about it?

Thanks in advance,

best regards, Johnny

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jun 21, 2010 at 04:25 AM

    Hi ,

    Use following

    SHIFT variable RIGHT/LEFT DELETING TRAILING '0'.

    For more variations ,

    just write SHIFT and press f4 , it will show you the information you need.

    Hope this is helpful,

    Regards,

    Uma Dave

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Uma Dave,

      Thanks for your reply.

      You know, the sum is done by the sap system. It's important to control the output by SHIFT statement and there is no place to write the statement.

      Thanks & Best regards, Johnny

  • Jun 21, 2010 at 01:03 PM

    Hi,

    There are some functionalities in the ALV fieldcatalog strucuture for this.

    Please go through that. Type Pools - SLIS.

    With Regards,

    Sumodh.P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 02:46 PM

    still ur not clear,

    you can use like

    fieldname = trunc( fieldname )

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 02:48 PM

    still ur not clear,

    you can use like

    fieldname = trunc( fieldname )

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 02:53 PM

    still ur not clear,

    you can use like

    fieldname = trunc( fieldname )

    Add comment
    10|10000 characters needed characters exceeded