Cannot perform calcs on lookup() arrays

Technical Help
1

Description:
When using lookup() in formulas, you cannot perform element-wise arithmetic operations on the returned arrays. For example:

lookup(‘link’, ‘price’) * lookup(‘link’, ‘quantity’)

Steps to reproduce:

  1. Create a Formula field that attempts to multiply two lookup arrays:

lookup(‘Orders’, ‘Price’) * lookup(‘Orders’, ‘Quantity’)

Error occurs:

“argument number 2 given to operator / was of type number but there are no possible types usable here”

Expected behavior:
Support element-wise operations on lookup arrays, similar to how other database/spreadsheet tools handle array formulas, OR provide a function like array_map() to apply operations across array elements.

Example use case:
Calculate total commission per user by looking up amounts and percentages from linked records and computing:

sum(lookup(‘Commissions’, ‘Amount’) * lookup(‘Commissions’, ‘Percentage’))

2

Hey @Sulitzer, this isn’t supported yet. Let me check with the team to see if it’s something we’re planning to introduce.

3

Hey @Sulitzer, we added this feature to our development list. :ok_hand:

1 Like
4

Hey @olgatrykush . I don’t want to annoy you, but this one also needs to be prioritized from software engineering perspective, just like @Rollup or sum formula fields :grin:

Is there any ETA on it, you’ve mentioned it’s been added to the list?

5

Hello @Sulitzer, we don’t provide ETAs unless a feature is already in development or at least on the shortlist. This one isn’t on the shortlist, so I can’t say, unfortunately.