JSRunnels Posted August 4, 2005 Posted August 4, 2005 I know this must have a very easy answer, but I can't seem to get it to work... I want a calculation field to show two decimal places -- even if they are zeros. The field sums two number fields. If the sum is "7", I want it to return "7.00". This is a simple, simple invoice. I have tried Round, Truncate and SetPrecision. It always returns "7". I know there must be an easy way to do this, but somehow I am missing it.... I have searched FMForums for decimals, cents, steprecision. No luck.... Please help!
comment Posted August 4, 2005 Posted August 4, 2005 Make the result of your calculation field a Number. In Layout mode, select the field and choose Format > Number... from the menu. Select "Format as decimal", and check "Fixed number of decimal digits: 2".
JSRunnels Posted August 4, 2005 Author Posted August 4, 2005 Thank you. I knew it would be easy. I just spent an hour trying to figure it out!!! I love FMForums.
Recommended Posts
This topic is 7150 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now