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 |