Shawn,
Any time you divide an integer number of cents you may end up with a
fraction of a cent. I would use the INT() function like this:
X.EMPLYR.AMT = INT(MO.PREM * 0.8)
and
X.EMPLYE.AMT = INT(X.EMPLYR.AMT / 2)
X.EMPLYR.AMT = X.EMPLYR.AMT - X.EMPLYE.AMT
I hope that helps!
Derek
Define a little more rigorous? Other than some rounding/truncation
issues, what exactly are you going for?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie
Sent: Tuesday, November 30, 2004 12:24 PM
To: [EMAIL PROTECTED]
Subject: [U2] [UD]
Hi Shawn,
Everything looks good, but what is the question? i.e., explain what you
mean by a little more rigorous.
i.e.i.e. you need to do ?what? to the data to satisfy the accountants...
Allen
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Shawn Waldie
Maybe they are paid semi-monthly (24 periods) rather than Bi-weekly (26
periods).
--
Donald Verhagen
Application Development Manager
[EMAIL PROTECTED]
Tandem Staffing Solutions, Inc.
1690 S Congress Avenue, Suite 210
Delray Beach, FL 33445 USA
Voice Phone: 561.454.3592 Fax Phone:
PROTECTED] Behalf Of Gyle Iverson
Sent: Wednesday, December 01, 2004 7:44 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UD] Precision
Hello, Shawn.
There are some odd cent differences to account for in the monthly amount
calculations. I used the Iconv() function to round the fractional cents
My thanks to all for the responses.
Shawn
-Original Message-
From: Shawn Waldie
Sent: Tuesday, November 30, 2004 1:37 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UD] Precision
I see a strong potential for penny-creep here unless I add/truncate
some zeros before/after I make