You are here: All Help Topics > Accounting and Assurance > Calculations, Functions and Linkages > INANN function
-- Reference --
INANN function
The INANN function tests whether there is an associated tickmark or reference annotation.
Syntax
INANN( type, ID , database )
Where...
| Type | Tickmark (T) or Reference (R) |
| ID | The textual ID of the tickmark or reference. Textual IDs can be found in the Text column in Engagement|Tickmarks. |
| Database | The alias of the database such as "AM, "GL", etc. |
-
Example
INANN("R", "", "AM") = 0 & INANN("T","", "AM") = 0
Only accounts in the AM database that contain a reference and tickmark will display. The ID field has been left blank in both instances to return all tickmarks and references. The & operator (AND) is used to join both conditions.
