5 Replies Latest reply: Apr 25, 2017 12:44 PM by Digvijay Singh RSS

    How to format decimal fields in script

    Cliff Clayman

      I have a few decimal fields from a SQL table that I need to format in the script.  The user does not want to see the decimals where the value is a round number.  For example, currently a value displays as 100.00 and the user wants to see 100.  However, if the value is 123.45, then I need it to display as 123.45.  Can I handle this in the script or do I do it on the report?