Show/Hide Toolbars

Navigation: » No topics above this level «

Compare: Calculation Features

Scroll Prev Top Next More

Calculation Features

Feature

Detail

FormCalc

FormCalc SST

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.

-

Created with Help & Manual 7 and styled with Premium Pack Version 3 © by EC Software