An expression can contain any combination of literal values, operators, functions, and references to data fields, as shown in the following examples. For detailed descriptions of the functions that Interactive Viewer supports, refer to a later section of this document.
The following expression displays a customer’s first and last names, which the database entry stores in two fields. The & operator concatenates string values.
The following expression calculates a gain or loss percentage. The expression uses the mathematical subtraction, division, and multiplication operators, -, /, and *.
The following expression uses the IF function to evaluate if the value in the country column is UK. If the condition is true, the function replaces the value with United Kingdom. If the condition is false, the country values are displayed as stored.