I've already changed the declaration from float4 to numeric.. 
It is working now..Thanks to you! ;)
However, the salvage value in my table is float4/real... Do i have to change it also 
to numeric?? The salvage value I'm referring to is actually a percentage value like 
user will input 10%, 35.5%..10 and 35.5 is stored in the table as float4/real..
Need another one of your good advices..

Michael Meskes <[EMAIL PROTECTED]> wrote:
On Wed, Oct 01, 2003 at 05:34:08PM -0700, Gezeala 'Eyah' BacuXo II wrote:
> salvagevalue float4;
> ...
> -- depexpense := ((acqamt - (acqamt * salvagevalue))/ life) * manth;

I haven't checked in detail but I guess that the whole calculation is
done as float since one variable is float. Please make sure numeric
calculation is used as the differences you see may very well come from
the float datatype.

Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: [EMAIL PROTECTED]
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

Marie Gezeala M. Bacuņo II 
IS Department
Muramoto Audio-Visual Phils., Inc.
MEPZ1, Lapu-Lapu City, Cebu, Philippines 6015

The person with the ultimate cachinnation possesses, thereby, the optimal cachinnation.

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

Reply via email to