I want to format a number in webi 4.1 using format number function
For example : 7241 as 72,41%
Can anybody help to get this format.
prashchoudhary (BOB member since 2010-01-08)
Hi,
Try this
formatnumber(;“#,####‘%’”)
Cheers!
Supernova 
(BOB member since 2013-08-30)
[Moderator Note: Moved from Desktop Intelligence to WebIntelligence XI]
Marek Chladny 
(BOB member since 2003-11-27)
I tried the below formula but its not working in webI 4.1
=FormatNumber([Percentage / savings];"#,#### ‘%’ ")
Its giving output as only % without numbers
prashchoudhary (BOB member since 2010-01-08)
Maybe it’s because your pourcentages are rounded to 0 and you don’t specify to display 0 in this case.
Try to replace the last # by 0.
Moreover if you want to have 7241 --> 72,41% you have to divide by 100 before.
My proposal:
=FormatNumber([Percentage / savings]/100;"#,##0 %")
lappro 
(BOB member since 2013-07-25)
you can use custom in format–number. In custom use can put 72.41% and it will work
surya_sudheer 
(BOB member since 2006-11-01)
Its not working at all…
Can anybody help me
prashchoudhary (BOB member since 2010-01-08)
Hil
Will this formula work?
=FormatNumber([Percentage / savings]/100;"###.## %")Marek Chladny (BOB member since 2003-11-27)
No its not working.
I need number to be displayed for eample 45,55%.
Is it possible…
prashchoudhary (BOB member since 2010-01-08)
and this ?
=FormatNumber([Percentage / savings]/100;"#,##0.00%")lappro (BOB member since 2013-07-25)
If I use the below formula:
=FormatNumber([Percentage / savings]/100;"#,##0.00%")
I am getting output as 000%
If i dont use any formula only drag&drop the measure varaible [Percentage / savings] i.e my output/ meaning without formula is
.45
.5
.49
Can you please guide me.
prashchoudhary (BOB member since 2010-01-08)
I don’t really understand what is your expected result.
For example for the .45 value, what do you want ? 45% ? 0.45% ? 0.0045% ?
Do you want to display 0 before comma when happening ?
In my previous formula I divided by 100 because I thought that you have to do it (in your 1st post you want 72,41% from 7241 value). But maybe it is not necessary, it depends if you have to transform the initial value except adding the percent symbol.
lappro (BOB member since 2013-07-25)
I want .45 to be displayed as 45,03%.
prashchoudhary (BOB member since 2010-01-08)
In this case I think you should use :
= Formatnumber([Your measure]*100;"#,##0.00%")Or you can directly change the format by selecting the cell and in Formatting tab and Numbers subtab, you can select the 123,456.70% format (the one before true;false).
lappro (BOB member since 2013-07-25)
I am getting 45.03%.But I need the output as 45,03%.
To be more precise i need comma and not dot in between.
prashchoudhary (BOB member since 2010-01-08)
Then change the , and . in the formatting code or change your country/language setup.
HenkK
HenkK 
(BOB member since 2004-03-02)
I don’t think that you can change the formula because in number formats, comma represents the thousands separator and the dot matches to the decimal separator.
But you can use the Replace function :
=Replace(Formatnumber([Your measure]*100;"#,##0.00%");".";",")lappro (BOB member since 2013-07-25)
Thanks it works.
prashchoudhary (BOB member since 2010-01-08)
As a second option
How can I change my country/language setup.
prashchoudhary (BOB member since 2010-01-08)
I chart I cannot makes same changes.Could you please let me know how to make country settings
prashchoudhary (BOB member since 2010-01-08)