September 15, 2010 at 8:10 pm
Hi,
in my report i have one column where it shows the percentage.
for example
10.15%
20.46%
25.43%
25.49%
i wnated this number to rounded of to the nearest deciaml
i need the out put like below
10.2%
20.5%
25.4%
25.5%
this is like normal way we round the to decimal numbers.
here for 10.15% the seconnd digit aftre the deciaml point is greated than or equl to five so it has to displal like 10.2
for 25.43% the seconnd digit aftre the deciaml point is greated than or equl to five so it has to display like 25.4
can this be done with the expressions in ssrs. if it can be done can you please help me with this.
thank you
September 16, 2010 at 3:31 am
=Round(10.15,1) & "%"
=Round(20.46,1) & "%"
September 16, 2010 at 3:56 am
Have you tried setting the format options of the textbox ?
September 16, 2010 at 4:50 am
Hi
Go Report Layout>>>Press F4>>>then Properties>>>Format>>>0.0%
Try That,it will...................
Sank
September 16, 2010 at 7:08 am
In the format value you can also put "p1" the "p" means percentage, the 1 means the number of decimal places. There are a number of shorthand formats the first digit n=numeric, c=currency, and p=percentage, the second digit is the number of decimal places you want.
So c2 is currency to 2 decimal places.
N5 is a numeric to 5 decimal places. etc.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply