4 Replies Latest reply on Jun 13, 2017 1:22 PM by swetzel

    Exporting a calculation field with 3 decimal places

    swetzel

      HI,

       

      I am trying to get a consistent export format from a calculation field.

       

      Lets say my calculation gives the following results

      1.23

      1.234

      1.2345

       

      I would like to get the following export results:

      1.230

      1.234

      1.235

       

      I use field formatting to get me leading zeros when I have a value less than 1.  I have used the Round() function to give me 1.235 for the third line. But I cannot get the first line to export 1.230.  It only exports 1.23

       

      How can I do this?