Description

PowerBuilder provides a variety of ways to work with decimal
values in DataWindow expressions.

Usage

The following arithmetic operators now return a decimal value
if both operands have a datatype of decimal:

If either operand is not a decimal, the returned value is
converted to a double datatype. The exponentiation operator (^)
returns a double

Relational operators that operate on numeric values, including =, >, <, <>, >=, and <=,
can take decimal operands. The precision of the decimal operand
is maintained in comparisons.

The following functions return a decimal datatype if their
arguments are decimals: Sum, CumulativeSum, Avg, Median, Count, First, Last, Max, Min, Large, Small, Var, VarP, Mod, Mode, Abs, Case, If.

The following functions return a decimal result instead of
a double: CrosstabAvgDec, CrosstabMaxDec, CrosstabMinDec,
and CrosstabSumDec.

The Dec function converts a constant string
to a decimal.

The Specify Retrieval Arguments dialog box includes the Decimal
and Decimal array types.

See also

• Dec