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:
|
Operator |
Meaning |
Example |
|---|---|---|
|
+ |
Addition |
Subtotal + Tax |
|
- |
Subtraction |
Price - Discount |
|
* |
Multiplication |
Quantity*Price |
|
/ |
Quantity*Price |
Quantity*Price |
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
