Multiplication formula? Any resolution?


#1

I’ve seen a couple of different places where other users encountered the same issue when trying to use a simple multiplication formula (it simply does not work gives #ERROR! I am using the asterisk. I’ve read every piece of information available and still am not finding any resolution. I’m going to be pretty pissed if after all the work I’ve done I have to abandon this because of this error in a very basic formula. I used ask a question already and no response yet. I kind of need to get it fixed or move on to something that actually works. I thought I had finally found a gem :frowning:


#2

We just resolved this over support, but for anyone else running into this issue: double-check that the column’s type is set to “number”. Numeric formulas won’t work with non-numeric column types such as text.


#3

Sorry, but this solution is not working and I too am ready to abandon ship and move on, back to writing SQL (which I hate but at least it can be wrestled to the ground!). I have what in database world should be kindergarten stuff. i calculate paychecks and there are 3 levels of par, straight, time and a half, and double. Collected hours are entered into a separate table for each level, all 3 of which link back to the pay day date. This all works perfectly, but the formula returns #error! for any multiplication I ask the it to do. All values, including the base rate of pay, are Number types. So:
{Straight Pay} * Rate returns #error!
{Straight Pay} / Rate returns #error!
{Straight Pay} + Rate returns the correct value
{Straight Pay} - Rate returns the correct value

What on earth? By the way, I am using 1.1.12. Is that possibly from before the bug was fixed?


#4

Hi Hiram, it looks like you may be encountering a separate issue. Could you please email support@airtable.com so we can look into it?


#5

I solved this and just thought I’d add it to the record.

The multiply operator * multiplies two numbers, but it cannot multiply other types like lookups. If you need to lookup a number and multiply it, cast it to an int before multiplcation.

Here’s an example from my table: {Qty/Pack}*{Packs/Kit})*INT({Kits Needed} - Qty/Pack and Packs/Kit are both simple number fields, but Kits Needed is a lookup to another table and needs to be cast to an int.


#6

Yeah, lookups are returned as arrays, which can also become a problem when dealing with multiple values, especially text values, since Airtable doesn’t have a full set of array functions (and no way to construct an array outside of a lookup, AFAIK).

In addition to using INT or VALUE, you can also use ARRAYJOIN to convert an array to a string.