AnsweredAssumed Answered

Forced Decimal Place Formula Help

Question asked by sportyguy209 on Jun 19, 2013
Latest reply on Jun 20, 2013 by sportyguy209

Title

Forced Decimal Place Formula Help

Post

I'm not a programmer, but usually manage to get FileMaker to do what I need it to do. However, I'm stumped on this one.

      
     I am trying to create a field that will always provide two decimal places.      
           
          15 should show up as 15.00
          15.1 should show up as 15.10
          15.01 should show up as 15.01
           
          This is the formula I have been using:
           
          Let ( [ d = Round ( Self ; 2 ) ; i = Int ( d ) ; f = ( d - i ) * 100 ] ; i & "." & Left ( f & "0" ; 2 ) )
           
          However, when I enter 15.01, the result is 15.10
           
          Can someone tell me a formula that will work?
           
          TIA

      

Outcomes