Re: Dollarformat -vs- Numberformat

2002-05-01 Thread Hatton Humphrey
Thanks for the reply, I ended up finding the cluprit in a difference of SQL statements... one page had select round(line.price * line.rec_qty) and another had just sum(line.price * line.rec_qty)... the difference ended up being on the SQL site of things. Thanks again! Hatton Bud wrote: On

Dollarformat -vs- Numberformat

2002-04-30 Thread Hatton Humphrey
Okay, this may have been asked a thousand times but I'm going to make it 1001. When comparing the Numberformat and Decimalformat funcitons (for CF 4.x) what is the difference when it comes to rounding and numeric accuracy? Here's the problem: I recently added a summary report to a financial

Re: Dollarformat -vs- Numberformat

2002-04-30 Thread Bud
On 4/30/02, Hatton Humphrey penned: Here's the problem: I recently added a summary report to a financial calculation page. The page has been using NumberFormat(tot_tot+misc_tot,9-$999,999,999.99) for several years (the application has been in live use since around 1998). The report that I