2 Replies Latest reply: May 15, 2014 9:54 AM by Peter _ RSS

    Adding a decimal point to a numeric field

    Peter _

      Hi,

       

      I have a report that has 7 digit field. I would like to add a decimal after the 5th digit.  I want to keep the field numeric because I need to add the columns.

      Examples:

       

      9999999

      0840432

      2109503

       

      I would like it to look like this:

       

      99999.99

      08404.32

      21095.03

       

      Anybody have any suggestions.

      Thanks

      Peter