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.
Logical
Logical operators are used in logical calculations.
Cell address
Cell address operators are used in calculations on ranges of cells and table relative cells.
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 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. |