Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Limiting Decimal points

Posted on 2012-04-04
4
Medium Priority
?
340 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
  • 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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Screencast - Getting to Know the Pipeline
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

885 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