Number formating using formating sheet

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

I used #,# to insert comma

[Shrikant_Jadhav]

Hi VSM,

Try this

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

Shrikant

[Former Member]

Thank you Shrikant

The custom format type you suggested help!

Giving me 2,500.00 for 250000000, now trying to remove that last zero so that it look as 2,500.0

[Former Member]

Hi Shrikant

what I want to display in report is

100000       as 1.0

1000000     as 10.0

10000000   as 100.0

100000000 as 1000.0

and so forth..

The format type you suggested works only for the last one.

hope you understand my requiremnet 🙂

[Shrikant_Jadhav]

Hi, VSM,

Best way to achieve is as suggested previously use   EPMScalData function

Shrikant

[Former Member]

Hi Shrikant,

have read few link ,

what i feel is that i should use the custom format type only (from formatting sheet) as i have to achieve this in all my reports and input forms. Also my reports and input forms have local members that cant be scaled using epmscaledata function.

more reply would be appreciated.

[Former Member]

Also want 100000000 as 1,000.0.

in short want to scale in lakh with comma....

[former_member212095]

Hi VSM

Alternative Option is to insert a column/row in your report and using EPMCOPY range function, divide the figures in 000 based on your desired results.

Regards

Gaurav

[Former Member]

Thanks gaurav for reply...

I think using copy range wont be correct in my case as i got to do this for all my reports and input forms those includes local members dimension members...my reports and input are dynamic too...

Thanks

[former_member186338]

Is it so hard to Google: "Excel lakh format" ?????

Vadim

[Former Member]

Hi Vadim,

Thanks for your time!

Have created custom format 0"."00,  by Google only..just trying to reduce last decimal and insert comma as per indian lakh format i.e comma after every three decimal.

no luck yet..please advice

[former_member210696]

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

[Shrikant_Jadhav]

Hi VSM,

You can use EPMScalData function

Shrikant