Description

The BRANCHLIST function returns the list of branches of one or more companies.

Syntax

BRANCHLIST(Connection, Company)

Parameters

The BRANCHLIST function uses the following parameters:

Parameter

Required/Optional

Description

Connection

Required

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

Company

Optional

The ID of the company. If left empty, the function will return all branches defined in the database

Example

=BRANCHLIST("Demo", "PRODUCTS")

Description: Returns the list of branches within the PRODUCTS company.

Result: PRODWHOLE, PRODRETAIL

Empty List

If a non-existent company name is specified, the BRANCHLIST function will either display the message Error! No element matches range xxxxxxxxx...

branchlist_empty_a2.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:

branchlist_empty_b2.png

Applies to

  • GL Module

Did this answer your question?