Entity Function
The ENTITY function is used to extract data from a specific entity in a consolidated Working Papers file. It is most commonly used within another function.
Syntax
ENTITY("abbreviation",expression)
Parameters
Abbreviation - The ID code for the entity entered in the Entity Properties dialog of the consolidated file.
Expression - Represents the data being requested for the entity.
Example | Description |
---|---|
MAP("PY",ENTITY("E2","115*")) |
Returns the prior year value of the account assigned to map number 115 from Entity E2. |