Calculated Values

Item Start (ITEMSTART)
Note: This function can only be used for RELATIONSHIPS and must be created in the relationship tab. ITEMSTART function is used to return a value of a sp...
Tue, 28 Jul, 2020 at 5:12 PM
Labels (LABELS)
LABELS function will return an array of labels for a specified attribute or calculated value. Syntax LABELS(x) Parameters x = Attribute/Calc...
Wed, 29 Jul, 2020 at 10:26 AM
Length (LEN)
The LEN function can be used in either a string or array setting and is used to return the length (number of characters including spaces) of a string or the...
Wed, 29 Jul, 2020 at 10:30 AM
Look Up (LOOKUP)
The LOOKUP function is similar to INDEXOF function and can be used to find the value at the specified index or location within an array. The return value in...
Wed, 29 Jul, 2020 at 10:32 AM
Maximum (MAX)
MAX function will find the maximum value of an array of numbers or dates. Syntax MAX([x,x,x,x,x]) Parameters x = The array of either dates o...
Wed, 29 Jul, 2020 at 10:33 AM
Minimum (MIN)
MIN function will find the minimum value of an array of numbers or dates. Syntax MIN([x,x,x,x,x]) Parameters x = The array of either dates o...
Wed, 29 Jul, 2020 at 10:34 AM
Related Items (RELATEDITEMS)
The RELATEDITEMS function is a powerful feature which can be used to return a set of items based upon their relationships and their directions. It is great ...
Wed, 29 Jul, 2020 at 10:41 AM
Replace (REPLACE)
REPLACE function is used to replace a specified part of a string. An array can also be used which can include DATE, TEXT or NUMERIC values, and the replacem...
Wed, 29 Jul, 2020 at 10:43 AM
Round (ROUND)
The ROUND function rounds the value up or down based on its value (up for values .5 or more between 2 integers and down for values less than .5). Syntax...
Wed, 29 Jul, 2020 at 10:45 AM
Round Down (ROUNDDOWN)
The ROUNDDOWN function will round the value down to the closest integer. Syntax ROUNDDOWN(x) Parameters x = the value that the user wishes t...
Wed, 29 Jul, 2020 at 10:46 AM