Post reply

Rounding the number

  • September 15, 2010 at 8:10 pm

    #227792

    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

    #1222007

    =Round(10.15,1) & "%"

    =Round(20.46,1) & "%"

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • September 16, 2010 at 3:56 am

    #1222016

    Have you tried setting the format options of the textbox ?


    Clear Sky SQL
    My Blog[/url]

  • September 16, 2010 at 4:50 am

    #1222047

    Hi

    Go Report Layout>>>Press F4>>>then Properties>>>Format>>>0.0%

    Try That,it will...................

    Sank

  • September 16, 2010 at 7:08 am

    #1222151

    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