Calculated Values

Concatenation (CONCAT)
The concatenation function is used widely to form a combined text string from several independent text variables which can include anything, with the most w...
Tue, 28 Jul, 2020 at 4:54 PM
Contains (CONTAINS)
The contains function can produce a TRUE or FALSE outcome, if the substring which the user defines is contained in the string. It can be used to gather spec...
Tue, 28 Jul, 2020 at 4:55 PM
Date (DATE)
The date function creates a date of a specific value of the user’s choosing.   Syntax   DATE(x,y,z)   Parameters   x = Year as a 4-digit integer.  ...
Tue, 28 Jul, 2020 at 4:55 PM
Has Tag (HASTAG)
The HASTAG function determines if an item possess a specific tag. This function is CASE SENSITIVE.   Syntax   HASTAG(“x”)   Parameters   x = Tag Nam...
Tue, 28 Jul, 2020 at 4:56 PM
Index Of (INDEXOF)
Finds the index or placement of a value within an array. The return value index is zero based, i.e., the first value in the list is 0 (zero).   Syntax   ...
Tue, 28 Jul, 2020 at 4:57 PM
Index of Lists (INDEXOFLIST)
INDEXOFLIST function is used to find the index of the assigned list value. It’s good at producing a numeric value for list values that follow a scale. The r...
Tue, 28 Jul, 2020 at 4:58 PM
Intersect (INTERSECT)
INTERSECT function can be used to return a collection of values common to both arrays. Syntax INTERSECT([x,x,x,x,x], [y,y,y,y]) Parameters x...
Tue, 28 Jul, 2020 at 4:59 PM
Item 1 (ITEM1)
Note: This function can only be used for RELATIONSHIPS and must be created in the relationship tab. ITEM1 function returns a value for Item 1 in a pair ...
Tue, 28 Jul, 2020 at 5:03 PM
Item 2 (ITEM2)
Note: This function can only be used for RELATIONSHIPS and must be created in the relationship tab. ITEM2 function returns a value for Item 2 in a pair ...
Tue, 28 Jul, 2020 at 5:07 PM
Item End (ITEMEND)
Note: This function can only be used for RELATIONSHIPS and must be created in the relationship tab. ITEMEND function is used to return a value of a spec...
Tue, 28 Jul, 2020 at 5:09 PM