You are here: Help Topics > Accounting and Assurance > Calculations, Functions and Linkages > & Operator

& Operator

Used to combine two filter commands. Both conditions must be found true in order for the expression to be true.

Syntax

condition1&condition2

DATABASE -> FIELD OPERATOR VALUE&DATABASE -> FIELD OPERATOR VALUE

Example 1

GL->JOURSOURCE="AJ"&GL->JE_DESC="AMERICAN EXPRESS"

Filters for adjusting journal entries that have the description of "AMERICAN EXPRESS".

Both conditions are true and therefore the expression is true.

Tip: The journal description must match the description in the filter exactly or the filter will not select them. In order to find journal entries where "AMERICAN EXPRESS" is only part of the journal description, use other functions such as IN or SCANSTR to filter instead. To deal with issues of case difference, the description in the journal might be in lower case or a mix of upper and lower case, use the function UPPER ,or LOWER . More than one function can be used in a filter at a time. Functions can be nested in the filter to define the criteria. For using dates in a filter, see Date Fields for more information.

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

Filter Type	Database
Financial Statement	AM Database
Journal or Ledger	GL Database

& Operator

Database

Field

Comparison Operators

Value