Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6577 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.