Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions

Users Guide 751

Not in validation rules or filter expressions

You cannot use this or other aggregate functions in validation rules or filter

expressions.

Using an aggregate function cancels the effect of setting Retrieve Rows As

Needed in the painter. To do the aggregation, a report always retrieves all rows.

Examples This expression returns the sum of the values in group 1 in the column named

salary:

Sum(salary for group 1)

This expression returns the sum of the values in column 4 on the page:

Sum(#4 for page)

Assuming a report displays the order number, amount, and line items for each

order, this computed field returns the sum of the order amount for the distinct

order numbers:

Sum(order_amt for all DISTINCT order_nbr)

See also “Example 1: counting null values in a column” on page 630

“Example 2: counting male and female employees” on page 632

Tan

Description Calculates the tangent of an angle.

Syntax Tan ( n )

Return value

Double. Returns the tangent of n if it succeeds and –1 if an error occurs.

Examples Both these expressions return 0:

Tan(0)

Tan(Pi(1))

This expression returns 1.55741:

Tan(1)