Forced Decimal Place Formula Help
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?