subtraction questions

[Joey Martin]

I have a numeric field in my database.
How do I subtract?

frequencypercent is a decimal and in this case is .20

multiplierrate= 100 - rs_fees("classified_freq_percent")

 

[Joey Martin]

well, kind of worked.

The classified_freq_rate is actually .20
Therefore it should be 1 (i stated 100 earlier but meant 1) -.20 and equals
..80
But, using the cdbl, it shows 0.85

Any ideas?

 

[Mark Schupp]

See what is actually happening.

Response.Write rs_fees("classified_freq_percent") & "<br>"
Response.Write CDbl(rs_fees("classified_freq_percent")) & "<br>"
Response.Write (100-CDbl(rs_fees("classified_freq_percent")) ) & "<br>"
multiplierrate= 100 - rs_fees("classified_freq_percent")

Response.Write multiplierrate & "<br>"