Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Multiplying two fields

Topic Labels: Formulas
Solved
Jump to Solution
1308 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Christa_Patton1
5 - Automation Enthusiast
5 - Automation Enthusiast

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.  

Christa_Patton1_0-1695842314149.png

I get #ERROR 

Thank you for the help.  

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi @Christa_Patton1

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

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Hi @Christa_Patton1

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

Christa_Patton1
5 - Automation Enthusiast
5 - Automation Enthusiast

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