Skip to Content

Number formating using formating sheet

Hi Gurus,

I am trying to achieve this

Value in backend 250000000 , want to display it as 2,500.0

So far have created a custom format  0"."00,  that make the value look as 2500.00

Please advice.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 05, 2015 at 08:48 AM

    Thanks guys...

    Thanks Ashish i did the same way :-) got it from chandu.org link

    I used #,#.0,,, ctrl J %% then wrap text...

    Thanks for all your replies

    VSM

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 01, 2015 at 11:58 AM

    Hi VSM,

    You can use EPMScalData function

    Shrikant

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 01, 2015 at 12:00 PM

    Hi VSM,

    Try this

    #","##0"."00,

    Shrikant

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vsm K

      Hi VSM,

      This is how you can do it -

      1. In formatting sheet, type below in custom formatting-

      0.0######,,,Ctrl+J%%

      Ctrl + J should be pressed after entering three commas and then it should be followed by two %%

      2. Use "wrap text" on the same cell in the formatting sheet.

      Refresh report and the cells on which this formatting is applied using formatting sheet should display 2500.0 for 250000000

      Regards,

      Ashish