Problems adding and subtracting - End up w/ Exponential value

i have problem script i'm writing... when subtract 1 vale , product should zero, end exponential value insted. strange, of time come out correct balance of zero?
here script... values stores nvarchar on sql server.
any appreciated!!! have been trying figure out couple of weeks now.

<cfset debittotal = 0>
<cfset credittotal = 0>
<cfset creditadjust = 0>
<cfset debitadjust = 0>
<cfoutput query="getentries">
<tr>
<td>#entrydate#</td>
<td>#entrydescription#</td>
<td>#entrytype#</td>
<td><cfif #debit# eq 0>
 
<cfelseif entrytype eq 'rma'>
(#debit#)
<cfset debitadjust = #debitadjust# + #debit#>
<cfelse>
#debit#
<cfset debittotal = #debit# + #debittotal#>
</cfif></td>
<td><cfif #credit# eq 0>
 
<cfelseif entrytype eq 'caa'>
(#credit#)
<cfset creditadjust = #creditadjust# + #credit#>
<cfelse>
#credit#
<cfset credittotal = #credittotal# + #credit#>
</cfif>
</td>
</tr>
</cfoutput>
<cfset credittotaladjusted = #credittotal# - #creditadjust#>
<cfset debittotaladjuested = #debittotal# - #debitadjust#>
<cfset balance = #debittotaladjuested# - #credittotaladjusted#>

ok, got fixed (i think). being adding , subtracting currency rounded 2 decimal places. used decimalformat() before try subtract values , looks holding , returning need.

i ended getting solution following thread.
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=3&threadid=12 28485&highlight_key=y&keyword1=subtract

More discussions in ColdFusion

adobe