Cell Operators

The following operators are accepted as part of any CaseView calculation. Use these operators to present the desired values within CaseView cells or as criteria for skipping a line or section. Operators within parentheses are given precedence in evaluating any calculations. Operators are calculated in a specific order.

Arithmetic

Arithmetic operators are used to perform mathematical calculations to alter the values presented in cells.

• * Operator

• / Operator

• - Operator

• + Operator

Logical

Logical operators are used in logical calculations.

• & Operator

• | Operator

Cell address

Cell address operators are used in calculations on ranges of cells and table relative cells.

• .. Operator

• :: Operator

Database

Database operators are used in calculations referencing Working Papers or Time databases.

Syntax

DATABASE->FIELDNAME

Example

A database filter as follows:

AM->DIV = 1

In the above example, the financial statement will display only the records in the draft financial (AM) database that have the number 1 in the DIV field, which represents the division number in the Report setup.

Please refer to these topics for listings of valid field names in the AM (Trial Balance), MP (Mapping), and SH (Document Manager) databases.

Comparison

Comparison operators are used to compare values.

Operator	Description	Syntax	Example
<	Less than	value1<value2	C1<C2 Condition is true if cell C1 is less than cell C2.
<=	Less than or equal to	value1<=value2	C1<=C2 Condition is true if cell C1 is less than or equal to cell C2.
>	Greater than	value1>value2	C1>C2 Condition is true if cell C1 is greater than cell C2.
>=	Greater than or equal to	value1>=value2	C1>=C2 Condition is true if cell C1 is greater than or equal to cell C2.
=	Equal to	value1 = value2	C1 = C2 Condition is true if cell C1 is equal to cell C2.
<>	Not equal to	value1<>value2	C1<>C2 Condition is true if cell C1 does not equal cell C2.