
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 09, 2024 06:46 AM
is it there is a way, preferably with formula/s, 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]?
_
I would also need a formula for:
Column1 (array 1): 2, 3, 5
Column2 (array 2): 5, 4, 1
Expected output: 7, 7, 6
is this achievable?
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 09, 2024 07:21 PM
Could try using ARRAYSLICE() for it maybe? You'd end up with a pretty hardcoded formula field though
