Previous Topic: Using Function FieldsNext Topic: Count (CNT)


Function Field Usages

Type

Description

Data Type

Example

DRV

USR

User defined logic

User-defined field

Any

Any

Value = Price + Quantity

Control total

CNT

MAX

MIN

SUM

Count of records

Maximum value

Minimum value

Sum of fields

Numeric

Numeric

Numeric

Numeric

Number of lines on order

Largest item on order

Smallest item on order

Order total

Usage types of function fields are listed and described in the pages that follow.

See the chapter "Defining Functions" in Building Applications for more information.