BALDESC Function
The BALDESC function returns the value of a specified property for a Custom Balances item.
Syntax
BALDESC(Identifier, <property>)
Where
Identifier is the Balance Identifier for the Custom Balances item. <property> is optional and controls the property of the Custom Balances item that is returned. If omitted, the name is returned. Values for <property> are as follows:
| Value | Description |
|---|---|
| 0 | Returns the name. |
| 1 | Returns the Abbreviated Heading. |
| 2 | Returns a value indicating the Years setting. |
Note: When using a value of 2 for the <property> parameter, it returns a blank value if the Custom Balances item Years setting is Current/Past. If Years is Current/Future, it returns "Y".
Example 1
BALDESC("IT")
Returns the Name of the Custom Balances item with identifier IT.
Example 2
BALDESC("IT", 1)
Returns the Abbreviated Heading of the Custom Balances item with identifier IT.
