Absolute

Absolute is a mathematical function that returns the absolute value of a numeric value, row, column, or cell. The absolute value of a number is that number's distance from zero without regard to its sign. A negative number becomes positive, while a positive number remains positive.

Syntax:

Absolute(argument)

where argument is one of the following values:

Argument	Description
numeric	A numeric value. For example, Absolute(-20) returns the value 20. Numeric values can include decimals and negative values. See Numeric Arguments.
row, column, or cell reference	A pointer to a row, column, or cell within a grid.
function	An embedded function. See Mathematical Functions.

Examples:

Return the value 30:

Absolute(-30)

Return the absolute value of the value in row 1:

Absolute(row[1])

Point to expanded rows 1 through 3 within design segment 3 of Grid1:

Absolute(Grid1.row[3(1:3)])