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 s1, 2, 3] and d4, 5, 6] respectively, can I write a formula that produces s4, 10, 18]?

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