Solved

Limiting Decimal points

Posted on 2012-04-04
4
326 Views
Last Modified: 2012-04-13
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
0
Comment
Question by:Krisraychris
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 25

Expert Comment

by:Will Loving
ID: 37814443
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
 

Author Comment

by:Krisraychris
ID: 37826608
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
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 total points
ID: 37827015
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
 

Author Closing Comment

by:Krisraychris
ID: 37841864
Thank you .I had a source field which was I rounded and sorted out the problem.
Thank you
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question