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.

Related Topics