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.

## Comments

0 comments

Please sign in to leave a comment.