AnsweredAssumed Answered

Exporting a calculation field with 3 decimal places

Question asked by swetzel on Jun 13, 2017
Latest reply on Jun 13, 2017 by 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?

Outcomes