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
