Structured reference

A structured reference to a table column, such as Ventes[Montant], links a formula to the contents of a table rather than to a fixed address. It follows the table's extension without manual correction. The [@Montant] notation designates the value of the current row.

Example

=[@Quantité]*[@Prix]  // row-by-row calculation in a table

Related concepts

The whole glossary