none
How to two numbers after decimal in SSRS

    Question

  • Hello,

    I am using below expression, i would like to get two numbers after decimal, could please suggest me with suitable expression in SSRS 2008 R2.

    ="Size"+" "+ (Fields!Size.Value.ToString()) +"   " +"Diff_Perc"+" "+(Fields!Diff_Perc.Value.ToString())

    Thanks.

    Wednesday, September 14, 2011 12:16 PM

Answers

  • RPReddy,

     

    Try this,

    ="Size"+" "+ FormatNumber(Fields!Size.Value.ToString() ,2) +"   " +"Diff_Perc"+" "+ FormatNumber(Fields!Diff_Perc.Value.ToString(), 2)

    Regards,
    Manoj
    *Happy to help
    http://experiencingmsbi.blogspot.com/
    Experiencing Microsoft BI
    • Edited by Manoj A Wednesday, September 14, 2011 12:50 PM
    • Proposed as answer by KEROBIN Wednesday, September 14, 2011 12:59 PM
    • Marked as answer by RP Reddy Wednesday, September 14, 2011 1:05 PM
    Wednesday, September 14, 2011 12:49 PM

All replies

  • If i understand your requirement correctly then set  "N2" in the format property of the textbox.
    Wednesday, September 14, 2011 12:38 PM
  • RPReddy,

     

    Try this,

    ="Size"+" "+ FormatNumber(Fields!Size.Value.ToString() ,2) +"   " +"Diff_Perc"+" "+ FormatNumber(Fields!Diff_Perc.Value.ToString(), 2)

    Regards,
    Manoj
    *Happy to help
    http://experiencingmsbi.blogspot.com/
    Experiencing Microsoft BI
    • Edited by Manoj A Wednesday, September 14, 2011 12:50 PM
    • Proposed as answer by KEROBIN Wednesday, September 14, 2011 12:59 PM
    • Marked as answer by RP Reddy Wednesday, September 14, 2011 1:05 PM
    Wednesday, September 14, 2011 12:49 PM