
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 18, 2020 04:24 AM
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!!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 18, 2020 05:20 AM
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”?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 18, 2020 05:31 AM
Hi Julian
thanks for your reply , i change it “” already, but still can’t work! :sob: 4|700x248
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 18, 2020 05:58 AM
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?
