The following functions are available for creating Calculations in TapClicks. NOTE: Items in bold are required.
Name | Format | Description |
SUM | SUM(value1, [value2, …]) | Sum of a series |
AVERAGE | AVERAGE(value1, [value2, …]) | Average of a series |
MIN | MIN(value1, [value2, …]) | Minimum value of a series |
MAX | MAX(value1, [value2, …]) | Maximum value of a series |
COUNT | COUNT(value1, [value2, …]) | Number of values in a series |
UNIQUECOUNT | UNIQUECOUNT(value1, [value2, …]) | Number of unique values in a series |
UPPER | UPPER(text) | Converts text to upper case |
LOWER | LOWER(text) | Converts text to lower case |
SUBSTRING | SUBSTRING(text, start, length) |
Extracts parts of a text, beginning at the position specified (start) and returning the specified number of characters (length) |
TRIM | TRIM(text) |
Removes leading, trailing, and repeated spaces in text |
CONCAT | CONCAT(text1, text2) |
Joins two texts |
REPLACE | REPLACE(text, new_text) |
Replaces part of a text with a different text |
LOCATE | LOCATE(text, subtext, [start]) |
Returns the first occurrence of a the subtext in the text. If the subtext is not found, the function returns 0. Start is the starting position for the search. Position 1 is default. |
IF | IF(logical_expression, value_if_true, value_if_false) |
Returns one value if logical expression is TRUE and another if FALSE |
THEN | THEN |
Execute the following when the IF statement is true |
ELSE | ELSE |
Execute the following when the IF statement is false |
ELSEIF | ELSEIF(logical_expression, value_if_true, value_if_false) |
Execute the following IF statement when the prior IF statement is false |
END | END |
End the execution |