New & Revised Aggregate Functions
\The Sandbox \PB History & Future \New in PB 2 \Painter Features \DataWindow Painter \Aggregate Functions
Assigning
Accelerators
Tag Values
DW Icon
Comments
Changing
Databases
Controlling DW
Updates
OLE Columns
DataWindow
Reports
Dynamic DWs
Runtime Print
Specifications
Displaying the
DDLB Arrow
Displaying
Row Counts
Sort and Filter
Testing
Modifying Result
Sets Descriptions
Moving Object
with Keyboard
Naming Objects
Aggregate
Functions
New Color Bar
Events
DW Functions
New Menu Items
Grid Style
Shortcut Keys
Align Objects
Size Objects
Space Objects
Saving DWs
with Comments
Keyboard Object
Selection
Selecting a Font
Selecting a
Line Edit
Keyboard Sizing
Specifying
SQL Syntax
Background
Color
Timer Interval
Unit of Measure
Validation
Message
DB Table
Changes
Suppressing
Repeating Values
Testing an
OLE Column
Using Comments

    Avg
    Count
    CumulativePercent
    CumulativeSum
    First
    Last
    Max
    Min
    Page
    PageCount
    Percent
    StDev
    StDevP
    Sum
    Var
    VarP

Note:    You cannot use these functions in scripts; you can use them only in the DataWindow Painter.  Also, do not to confuse the Max and Min aggregate functions with the PowerScript Max and Min functions that compare two numbers and return the maximum or minimum number.

PBL Peeper PB Help PB History
& Future About Us Feedback Site Map

Google
 
Web www.techno-kitten.com
www.sybase.com