Jarvis Posted January 22, 2007 Posted January 22, 2007 I have a variety of number fields that are populated as a result of an AUTO ENTRY calculation. The results often times have a decimal somewhere in them. These fields are formatted to read as whole integers. 3.4 displays as 3 5.4 displays as 5 The sum of 3.3 + 5.3 currently displays as 9 I would like it to display as 8. (I would also like to have the mathematical result = 8) [color:red]Is there a way to make the values always round up or down at the half-point & present the result as a true integer? What I would like is: 5.4 = 5 5.6 = 6 5 + 6 = 11 Any ideas? Thanks, Jarvis
comment Posted January 22, 2007 Posted January 22, 2007 You can display a field in many ways, but this has no effect on the value in the field. You could either include rounding in your original auto-entered calculation, or use: Round ( Field 1 ; 0 ) + Round ( Field 2 ; 0 ) for the sum calculation.
Jarvis Posted January 22, 2007 Author Posted January 22, 2007 Thanks Comment, you helped a lot! Jarvis
Recommended Posts
This topic is 6577 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