Eval

Eval is a mathematical function that evaluates an expression. You use Eval as an embedded function argument to consolidate multiple expressions into one expression. The function syntax:

Eval(expression)

where expression is one or more of these arguments:

Argument

Description

numeric

A numeric value. Numeric values can include decimals and negative values.

row, column, or reference

A pointer to a row, column, or cell within a grid. References can be specified in several ways. The reference syntax: GridName.GridElement[segment(range)].Property

function

An embedded function

operators

Use any of the supported arithmetic operators (+, -, *, /, ^, %, and so on).

Example

The following example divides row 1 by row 2 and then rounds the data to four places:

  Round(Eval([1]/[2]),4)