Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Element-wise multiplication of two arrays of numbers

Topic Labels: Formulas
237 0
Showing results for 
Search instead for 
Did you mean: 

Hey all, I’m wondering if there is a way to perform element-wise multiplication of two arrays of numbers. For example, if I have two fields with arrays [1, 2, 3] and [4, 5, 6] respectively, can I write a formula that produces [4, 10, 18]?

As an example use case, I could calculate a weighted average of an array of numbers [10, 20, 30] with weights [.2, .5, .3]. After element-wise multiplication, I could take the sum with SUM([2, 10, 9]) = 21 (In this example, I’m just taking the dot product of these two arrays).

0 Replies 0