Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

CrosstabSumDec – PB Docs 2021 – PowerBuilder Library

CrosstabSumDec – PB Docs 2021

CrosstabSumDec

DataWindow expression function

Description

Calculates the sum of the values returned by an expression in the
values list of the crosstab and returns a result with the decimal
datatype. When the crosstab definition has more than one column,
CrosstabSumDec can also calculate the sum of the expression’s values for
groups of column values.

For crosstabs only

You can use this function only in a crosstab DataWindow
object.

Syntax

Argument

Description

n

The number of the crosstab-values expression for
which you want the sum of the returned values. The expression’s
datatype must be numeric.

column (optional)

The number of the crosstab column as it is listed in
the Columns box of the Crosstab Definition dialog box for which
you want intermediate calculations.

groupvalue (optional)

A string whose value controls the grouping for the
calculation. Groupvalue is usually a value from another column in
the crosstab. To specify the current column value in a dynamic
crosstab, rather than a specific value, specify @ plus the column
name as a quoted string.

Return value

Decimal. Returns the total of the values returned by expression
n for all the column values or, optionally, for a subset of column
values.

Usage

Use this function instead of CrosstabSum when you want to return a
decimal datatype instead of a double datatype. For more information, see
CrosstabSum.

See also

CrosstabAvgDec

CrosstabMaxDec

CrosstabMinDec

Decimal support in
DataWindow expressions


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x