Version 3.6 SELECT function change

2.75K viewsFormulas and Functions

One thing to note with Quantrix version 3.6 that it is now good practice to Sum your Select functions.

If you have a formula that looks like this:

item = select(valueList, keyList, lookupValue) + value

If the select statement returns nothing (blank) then the entire formula will return a blank. We made this change because in models in utilizing Select’s and Using As, there was some errors occurring in the key lookup due to how the system was treating “nothing”.

Now, whenever you are using a select it is a good idea to wrap it in a SUM function. That way any blanks will return a value of zero which will make the formula calculate the desired result. So the formula would look like:

item = sum(select(valueList, keyList, lookupValue)) + value

Please contact [email:1m5ovv83][/email:1m5ovv83] with any questions.