Limiting Decimal points

Hi

I have two layouts and one is a copy of the other.
In Layout A Table 1
I have a time field showing hh mm ss.This field is a calculation of number of hours to complete a task.Set as Time in the calc  eg 5:04:12 and the filed displays just that which is what I want.When I click in  this field the the result is expanded to show 5:04:129999999.

In Layout B Table 2
The same result appears but is is confined to hh mm ss and does not expand to multipl decimal points.

The Data in both cases is formated to Time ''As Entered''

I know it is a simple issue and would appreciate some direction on this
KrisraychrisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Will LovingPresidentCommented:
If both fields are identically formatted to "As Entered", my guess is that it would have to do with differences between the calculations in the two fields. Make sure that both calculations who "Time" as the result type and are structured similarly. Also, as an experiment, try recreating both calculation fields from scratch in two new fields, one in each table, and then see if you get the same result.

It doesn't sound like a formatting issue, but you can always try copying the field on one table and placing that copy of the other table. Then, double-click on the field you just copied and change it to the local field in the table the layout is based on. If it's a formatting issue it should show the difference between the two layout fields that both reference the same calculation.

If that still doesn't do it, create and upload a sample file that just has the two tables and the fields necessary for the calculation, along with a layout for each table showing one working one way - not rounded - and one with rounding of the decimal.
0
KrisraychrisAuthor Commented:
Thanks for the input.I have tried the options you suggested.There seems to be no consistency and could be a result of the extensive script that is associated with these fileds.
I thought a simpler solutoion might be to create a duplicate of the field and set it to Round the number.This works but I dont think it is the right way to go.I will work throgh it in greater details and try to find the source of the problem.
0
Will LovingPresidentCommented:
I curious about your comments about "the extensive script that is associated with these fields"... Are these simply Time fields that you are setting the value in using a script or are the Calculation fields with Time results? Either way, if you can upload a sample file with the calculations (or script) I can take a look at it.

Sometimes creating a sample file can actually help solve a problem like this because it forces you to eliminate variables. If the problem disappears, then it's something you took out to make it simpler for the sample; if it's still there then you have fewer variables left to consider. It does sound like the issue is with the calculation, whether scripted or in the field definition.

However, the one other thing that comes to mind is to look at the original source values. Sometimes an unrounded decimal such as you are seeing is there from the start in one of the values that you are using to perform the calculation rather than a result of the calculation you are performing. I've had this happen more than once over the years!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
KrisraychrisAuthor Commented:
Thank you .I had a source field which was I rounded and sorted out the problem.
Thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.