Building an expression
The expression builder in Interactive Viewer supports typical mathematical functions, such as percent of total, running sum, and percent of difference. It also supports a range of financial, logical, date‑and‑time, text, and comparison functions.
Table 6‑1 lists the functions available in each category of the expression builder.
Table 6‑1 Categories and functions for creating a computed measure
Category | Function |
Logical |  IF |
Financial | % OF % OF DIFFERENCE RUNNINGSUM |
Text | FIND LEFT LEN LOWER RIGHT SEARCH TRIM TRIMLEFT TRIMRIGHT UPPER |
Math | ABS ADD CEILING DIFFERENCE MOD PRODUCT RANK RATIO ROUND ROUNDDOWN ROUNDUP SQRT |
Comparison | BETWEEN IN IS NULL LIKE NOT NULL |
Date‑and‑time | NOW TODAY |
A detailed description of all functions is available in a later section of this document.