Add, subtract, multiply, divide

Across columns on an invoice, sales order, or other form.

Total or subtotal a column

Vertical totals and subtotals of columns.

Chain calculations

A single formula can reference data from multiple columns on the form.

-

If-Then logic functions

Formulas can make decisions based on data on the form.

-

Statistical functions

COUNT, AVERAGE, etc.

-

Date and time functions

NOW, TODAY, etc.

-

Text handling functions and text formula results

LEFT, TRIM, UPPER, etc.

-

Write results to the target application's detail area

Write calculated results to the "activity table" (line items) of a form.

Use header field data in calculations

Formulas can reference data stored in header fields of a form.

-

Write results to header or footer fields

-

"Mini-spreadsheet" capability

Formulas can access data from multiple rows of the a form's "activity table" (line items) area to do calculations.

-