Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert Number field to decimal so I can multiply for total

Status
Not open for further replies.

help2711

MIS
Feb 17, 2005
2
US
Hello,

I am new to Crystal and I need to know how too multiply a number field * decimal field.

What steps need done for this to happen?

Question:
Multiply the standard item cost by the quantity, and provide a total item cost per job in a seperate column.

I know how to multiply

{item.std_cost}*{job_line.qty} but it comes up with error telling me it needs a number?
Which obviously has something to do with the quantity field being a number and not a decimal field.

Please help!!!!!!!!!!!!
 
can u tell me the datatypes of each fld used.
if they of diiff types try to convert to same type
(tonumber({item.std_cost}) * tonumber({job_line.qty}))
 
Thanks

That worked I appreciate it it very Much!!!!!!!!!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top