Error when multiply two number

hi,
i’m trying to do a simple multiplication formula, Qty * Unit Price , but it come out #error , anyone can help me to solve this problem , thanks!!

Hi Eric - welcome to the forum! Your formula won’t work because Airtable doesn’t view the “Unit price” field as a number. Since “N/A” is text (aka “string” type), it assumes that the whole field is a string. You can’t multiply a number times a string. Can you design your first formula to leave fields blank instead of “N/A”?

Hi Julian
thanks for your reply , i change it “” already, but still can’t work! :sob:4|700x248

Hmmm. Your code looks fine. I even tried re-creating your original formula with the Value() function, and that worked as well. Can you share the base?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.