Is the problem that you have a global -- and which context is it referring to? A normal calc field refers to the current record.
Forbes -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Lee Sent: 10 September 2008 10:58 To: [email protected] Subject: Help major problem Hi, I have struck something I cannot come to grips with. I have a script that uses a global field. That global field is a simple calculation of two figures, payment-amount due. I have a payment figure of $8,932 and an amount due of $198. The difference is obviously $8,734 however the global field displays $8,701 which is $33 different. If I change the global field to a non global field it displays $8,734 the correct figure. When I change it back as a global it again displays $8,701 completely wrong. I have recreate a new global calc field to see if the field was corrupt but every time I create a global field it gives the wrong answer. Has anybody found this before and how do you fix it ? It only does it on some clients not all. Sometimes it displays the correct calculated figure but other times it displays the wrong calculated figure, a totally useless scenario as you would appreciate. I've never struck this before and its driving me mad for something so simple. The calculation is a 'number' and nothing is changed apart from the field either being a global or a standard calc field but gives a different calculated answer depending on its setting. I have tried this file on both Mac and PC's with the same result, so if you have any ideas please let me know. FMP9.0v3 mac (Leopard) and PC(XP2) -- Lee Mills -- ******************************************************************************** The information in this email and any files transmitted with it is confidential and may be legally privileged. It is intended solely for the addressee and others authorised to receive it. If you are not the intended recipient,, any disclosure, copying, distribution or action taken in reliance on its contents is prohibited and may be unlawful. Prospects Services Limited is a limited company registered in England and Wales. Reg No: 3042176 Registered Office: Prospects House, 19 Elmfield Road, Bromley, BR1 1LT. If you have received this email in error please notify: [EMAIL PROTECTED] http://www.prospects.co.uk This footnote also confirms that this email message has been swept for the presence of computer viruses ********************************************************************************
