DEFINE FILE DETAIL
AVGDispatchesPerTrailer/D12.2 = DispatchesPerTrailer/13;
END

TABLE FILE DETAIL
SUM
COMPUTE PCTCHG/D8.2%=( &CURRENTDISPATCHESPERTRAILER - AVGDispatchesPerTrailer ) / AVGDispatchesPerTrailer * 100; 
ON TABLE HOLD AS AVGDATA

quote:

The details of rounding are handled in the following ways for the following numeric formats:

Integer format When a value with decimal places is assigned to an integer field, the value is rounded before it is stored. If the value is assigned using a DEFINE or COMPUTE command, the decimal portion of the value is truncated before it is stored.

Packed-decimal format When a value is assigned to a packed-decimal field, and the value has more decimal places than the field format specifies, the value is rounded before it is stored.

Floating-point single-precision and double-precision formats When a value is assigned to one of these fields, and the value has more decimal places than the field format specifies, the full value is stored in the field (up to the limit of precision determined by the field internal storage type). When this value is later displayed, however, it is rounded.

Note that if the decimal portion of a floating-point value as it is internally represented in hexadecimal floating-point notation is repeating (that is, non-terminating), the repeating hexadecimal number is resolved as a non-repeating slightly lower number, and this lower number is stored as the field value. In these situations, if in the original value of the digit to be rounded had been a five (which would be rounded up), in the stored lower value, it would become a four (which is rounded down).

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

-SET &VAR = 2.45;
DEFINE FILE CAR
RCST1/P12.5 = RETAIL_COST / 1500;
END
TABLE FILE CAR
SUM RCST1
    COMPUTE RCST2 /P12.5 = RETAIL_COST / 1500;
    COMPUTE AVG1  /P12.2 = (&VAR - RCST1) / RCST1 * 100;
    COMPUTE AVG2  /P12.2 = (&VAR - RCST2) / RCST2 * 100;
BY COUNTRY
BY CAR
END