Solved

Limiting Decimal points

Posted on 2012-04-04
4
325 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 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

831 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