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.

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2