Description

The BRANCHNAME function returns the name of a specified branch ID.

Syntax

BRANCHNAME(Connection, Branch)

Parameters

The BRANCHNAME function uses the following parameters (see our article on using arrays or cell ranges as parameters):

Parameter

Required/Optional

Description

Connection

Required

The name of the connection, as specified in the Connection Manager

Branch

Required

The code of the branch.

Example

=BRANCHNAME("Demo", "PRODWHOLE")

Description: Returns the name of PRODWHOLE branch.

Result: Products Wholesale

If a non-existent branch code is specified, the BRANCHNAME function will display the message Branch 'xxxxx' not found...

branchname_notfound_1.png

or, if you have configured Velixo reports to return zero values under certain circumstances...

Options_return_zero.png

... your report will display Excel's #N/A error:

branchname_notfound_2.png

Applies to

  • GL Module

Did this answer your question?