Table

AddColumns

Returns a copy of a table with extra calculated columns. The source is unchanged.

Syntax

AddColumns(Table, ColumnName1, Formula1 [, ColumnName2, Formula2, ...])

AddColumns(Orders, LineTotal, Quantity * UnitPrice)

Orders with a LineTotal column