Syntax
With(Record, Formula)Examples
With({ subtotal: Sum(colCart, Qty * Price) }, subtotal + subtotal * 0.2)The total including 20% tax
Maker notes
- The names exist only inside the formula, which keeps long expressions readable.
Gives names to values for use inside one formula, without creating variables.
With(Record, Formula)With({ subtotal: Sum(colCart, Qty * Price) }, subtotal + subtotal * 0.2)The total including 20% tax