< All Topics

SELECT function

Often, when you have something that varies by an array, you want to choose just one item. The LOOKUP function lets you choose by name, whereas SELECT lets you choose by position. With SELECT, you can say ‘give me the first/ second/ etc array item for this calculation block’, whatever they are called.

The syntax is ‘SELECT([Formula to look up over],[position])’.


Suppose you have a line item called “Revenue”, which varies by the array “Product”. You sell 5 products. You want to get the revenue for the 2nd product. This would be:

SELECT([Revenue], 2)

Leave a Reply

Your Cart

No Item Found
Subtotal 0
Shipping 0
Tax 0
Total 0