In a formula column, the NB_ELEMENTS() function displays the number of elements contained in selected columns.

Formula

NB_ELEMENTS(Column1,Column2)

Example 1

NB_ELEMENTS(Received documents)

Configurator

Result

I counted the number of items in the Document Received column to find out how many.

Example 2

NB_ELEMENTS(Received documents, Subscription)

Configurator

Result

I counted the number of items in the Documents received column + the number of items in the Subscriptions column to find out the number of items in my client's file.

Example 3

In the same way, I can count the number of items linked to another table.

NB_ELEMENTS(Invoice)

Configurator

Result

I counted the number of invoice statements in my Invoice column issued to a given customer.