none
How to show value upto 1 decimal place in RDL

    Question

  • Hi All,

    Can anybody know, how to show value in RDL upto 1 decimal palce like 55.6
    I need this without using textbox property. how can we do this in Expression??

    Please reply with solutions.
    Thanks in Advanced

    --Kalpesh
    Monday, May 18, 2009 3:03 PM

Answers

All replies

  • Try this,

    =FORMAT(Fields!COF.value, "N1")
    Rajesh Jonnalagadda http://www.ggktech.com
    Monday, May 18, 2009 3:20 PM
  • Rajesh,

    As per your previous solution for % sign after number, i want it same way like 55.6 % not 55.6789%

    So =FORMAT(Fields!COF.value, "P") gives 55.67%
    I want it 55.6% (only upto 1 decimal point)

    "N1" is not working as i have tried it as = (FORMAT(FORMAT(Fields!COF.value, "P"), "N1")

    Do you know how to show it upto 1 decimal

    --Kalpesh

    Thanks for your help anyways
    Monday, May 18, 2009 3:27 PM
  • Try this,

    =FORMAT(Fields!COF.value/100, "P1")
    Rajesh Jonnalagadda http://www.ggktech.com
    Monday, May 18, 2009 3:33 PM
  • try this:

    =round(Fields!A.value, 1)

    Chrry-tree
    Monday, May 18, 2009 4:10 PM