![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The following table describes the syntax that results when operations are performed on numeric fields with a variety of syntax types. Where the number of decimal places or the length of the result can vary, more information is given for each arithmetic operation.
If an arithmetic operation causes an overflow, the computation is attempted in floating point syntax.
1st Operator Syntax 2nd Operator Syntax Result Syntax D=MIN(MAX(D1,D2), DMAX)) D=MIN(D1+ D2, DMAX)
Maximum number of decimal places that the result can hold without overflowing the integer portion.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |