I have programmed a new field in my database and for some reason, it is rounding to the dollar; not even the nearest dollar i.e.  $ 1,088.87 rounds to $ 1,088;  $ 1,088.25 rounds to $ 1,088 . 

I have checked the fields involved and they are all number fields formatted to two decimal places.

I went as far as inserting the @ROUND statement in my code but to no avail. 

Is there something I am missing ?

Here is my code if it helps.

Thanks,

Louis

var vJancomp as Int
var vNet as Int
var vNet1 as Int      

vJancomp = @ROUND(((ANNSALARY/12) + JANCOMM + JANHOLPAY + JANVACPAY + JANBONUS + JANOTHER), 2)
vNet = @ROUND(vJancomp - 7500.00, 2)
vNet1 = @ROUND(YRENDADVANC, 2)

//CALCULATES ADVANCES FOR THE MONTH
//ADVANCES ONLY PROVIDED TO TC'S AND BASED ON TC EARNING $ 7,500 GROSS BEFORE LOA DEDUCTION


If  DEPT = "ADM" OR DEPT = "CC" OR DEPT = "CS" OR DEPT = "EM" OR DEPT = "MKT" Then
{
     JANADVANCES = 0.00
}

ELSE

IF DEPT = "TC" AND vJancomp < 7500.00 THEN
{
     JANADVANCES = @ROUND(7500.00 - vJancomp, 2)
}
ELSE

IF DEPT = "TC" AND vJancomp > 7500.00 AND YRENDADVANC > 0.00 AND vNet > 0.00 THEN
{
     JANADVANCES = @ROUND(@MIN(vNet,vNet1), 2)  * -1.00
}
ELSE

IF DEPT = "TC" AND vJancomp > 7500.00 THEN
{
     JANADVANCES = 0.00
}

Ray:

I knew you had the answer !  Worked great.

I assumed an Integer was a number that could recognize decimals.

Thanks,

Louis