Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 749
Examples This expression is used in a compute field expression to remove the formatting
from a rich text edit column and display plain text in the compute field.
StripRTF(rte_description)
Sum
Description Calculates the sum of the values in the specified column.
Syntax Sum ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } )
Argument Description
string The column to be stripped of rich text formatting.
Argument Description
column The column for which you want the sum of the data values. Column
can be the column name or the column number preceded by a pound
sign (#). Column can also be an expression that includes a reference
to the column. The datatype of column must be numeric.
FOR range
(optional)
The data to be included in the sum. For most presentation styles,
values for range are:
• ALL – (Default) The sum of all values in column.
• GROUP n – The sum of values in column in the specified group.
Specify the keyword GROUP followed by the group number: for
example, GROUP 1.
• PAGE – The sum of the values in column on a page.
For Crosstabs, specify CROSSTAB for range:
• CROSSTAB – (Crosstabs only) The sum of all values in column
in the crosstab.
For Graph and OLE objects, specify one of the following:
• GRAPH – (Graphs only) The sum of values in column in the
range specified for the Rows option of the graph.
• OBJECT – (OLE objects only) The sum of values in column in
the range specified for the Rows option of the OLE object.