Juniper Systems Allegro CE Manual - Manual (Page 189)

Windows CE Page 4-129
Database Functions
Daverage(database, field, criteria) Averages the values in the specified
database column matching the conditions.
Dcount(database, field, criteria) Counts the cells containing numbers in
the specified database column matching the conditions.
Dcounta(database, field, criteria) Counts nonblank cells in the specified
database column matching the conditions.
Dget(database, field, criteria) Extracts a single value from the specified
database column matching the conditions.
Dmax(database, field, criteria) Returns the largest number in the specified
database column matching the conditions.
Dmin(database, field, criteria) Returns the smallest number in the
specified database column matching the conditions.
Dproduct(database, field, criteria) Multiplies the values in the specified
database column matching the conditions.
Dstdev(database, field, criteria) Estimates the standard deviation based
on a sample, using the numbers in the specified database column matching
the conditions.
Dstdevp(database, field, criteria) Calculates the standard deviation of a
population based on the entire population, using the numbers in the
specified database column matching the conditions.
Dsum(database, field, criteria) Adds the numbers in the specified database
column matching the conditions.
Dvar(database, field, criteria) Estimates variance based on a sample, using
the numbers in the specified database column matching the conditions.
Dvarp(database, field, criteria) Calculates the variance of a population
based on the entire population, using the numbers in the specified database
column matching the conditions.
Help
Use the on-line Help [?] located in the upper right-hand corner of the
display for more details about the PTab spreadsheet program.
▲ ▲ ▲ ▲ ▲ Automating Tasks
The Tasks function allows you to create simple spreadsheet
applications (macros) to automate tasks.