I think your probem stems from using a formatted (i.e. string) value in a
mathematical evaluation.  I would remove all output formatting functions
from your database formulas and apply them as needed within your templates
when displaying the values produced.

Jim


----- Original Message -----
From: "seth ward" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 11, 2000 12:11 PM
Subject: working with evaluate()


--------------------------------------
Problem (short description)
---------------------------------------
 if I set a variable, e.g. DISCOUNT, to equal
EVALUATE(NUMBERFORMAT(ORDERTOTAL - 100000)*0.1)) how do I then
recalculate ORDERVALUE less the discount?


------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to