calculated field question

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
mgonzales3
Posts: 11
Joined: Tue Oct 10, 2017 12:44 pm

calculated field question

Post by mgonzales3 » Mon Jun 02, 2008 7:37 am

The report has a simple field____1)Qty - 1,2,3 etc...__2)Value - $1.00, $2.00, etc...____I^m trying to create a calculated to multiply the two. Using version 8.1, I attempt to create the calculated field as qty * value. However, i receive an error box indicating that it is not valid expression.____The field is listed in the report as a currency data type.____The value amts are in the db(sql) as a money data type. The values are entered this way: 160.9000($160.90), 1.5000($1.50).____in VB the calculation is fine because i can say:__Format(myVar, "##,###,###.00") ____Is there a way this can be done in R&R?____Thanks,__manny______

Post Reply