I’d like this too. I want to perform a simple multiplication on each element within an array.
Have you found any workarounds, Andy?
I’d like this too. I want to perform a simple multiplication on each element within an array.
Have you found any workarounds, Andy?
Nope. Haven’t found any solutions yet. A cross-product like you are looking for would be useful as well.
I’d like this too. I want to perform a simple multiplication on each element within an array.
Have you found any workarounds, Andy?
HI
IS there a simple solution for this problem ,after 3 years?
Nope. Haven’t found any solutions yet. A cross-product like you are looking for would be useful as well.
HI Andy
Maybe you found out how to do thay?
HI Andy
Maybe you found out how to do thay?
The workaround is to perform the operation in a formula field in the original table, then roll up that formula field.
For example, say you want to add 5 to each value on the array before finding the average in a rollup. In the original, table, create a formula field that adds 5 to the original value. Then roll up this new formula field.
The workaround is to perform the operation in a formula field in the original table, then roll up that formula field.
For example, say you want to add 5 to each value on the array before finding the average in a rollup. In the original, table, create a formula field that adds 5 to the original value. Then roll up this new formula field.
Allright
Thank you!!
I complicated a simple issue…
בתאריך יום ד׳, 14 באוק׳ 2020, 18:46, מאת kuovonne via Airtable Community Forum <airtable@discoursemail.com>:
The workaround is to perform the operation in a formula field in the original table, then roll up that formula field.
For example, say you want to add 5 to each value on the array before finding the average in a rollup. In the original, table, create a formula field that adds 5 to the original value. Then roll up this new formula field.
Hi Kuvonne
Thank so much for trying to help.
At the beginning I thought your idea would work but unfortunately it doesn’t.
Here is a problem.
I must multiply each record with a parameter ( not a constant) . The parameter is different for each row.
For the first record it is X, for the second record it is Y,
At the original table , where I took the values, this parameters doesn’t exist. they are not relevant there. so I can’t prepare the data as suggested.
There must be a way to multiply each item in this record array.

Thanks
Ariel
|
Can you share a little more about your use case?
For example, are there always two values in the array? Could you instead use two conditional lookup fields that each return a single value, then multiply the values by their parameters before doing your final calculations?
Can you pass the multiplier back to the original record as a lookup field and do the multiplication in the original field?