Multiplying two fields

[Christa_Patton1]

Hi, I've looked up my situation to see what the problem is and I'm still getting an error message.  I want to multiply two fields to get a total.  Qty field and Cost field.  Here is my formula.  

I get #ERROR 

Thank you for the help.  

[Sho · Accepted solution]

Hi @Christa_Patton1、

One possible case is when either field is a string.
What does each field look like?

[Christa_Patton1]

Hi, @Sho Your question solved it for me.  I see I didn't have the QTY as a number but as text.  Thank you