HP 3000 Manuals

HP ALLBASE/BRW Reference Manual

Column Calculation Results 

Column calculations do not use the Calculation Language, and are
described in Chapter 8, "Defining Report Layout." However, column
calculation results can be used as arguments within layout calculations
or layout functions.  This is necessary, for example, to calculate the
percentage of variance between two column total values, as shown in the
following example.

The layout calculated item and its formula are:

          Item                                      Formula 

--------------------------------------------------------------------------------------

VARIANCE-%                (100 * ACTUAL - BUDGET) / BUDGET

On the Define Lines screen, VARIANCE-% for the break footing lineset on
ACCOUNT is specified as shown here:


            

The Define Lines screen is fully described in Chapter 16.

VARIANCE-% is calculated each time the value of the item ACCOUNT changes.
Because CALC is specified in the ColCalc field for this item, the total
values of arguments ACTUAL and BUDGET are used to find the percentage of
variance of these totals.  If you had not specified CALC, arguments
ACTUAL and BUDGET would have the value of whatever was on the last detail
line when the lineset was printed.

On the Define Lines screen, HP ALLBASE/BRW uses the definition of the
argument items found in the ColCalc and NumPrec field.  For example, if a
numeric precision for items ACTUAL and BUDGET had been specified in the
above example, the variance percentage would then have been calculated
from the totals with this precision.

Related Sections 

   *   Arguments

   *   Arrays and Array Items

   *   Aggregate/Array Operations

   *   Calculations

   *   Constants

   *   Expressions

   *   Functions

   *   Numbers (Defining Numeric Precision)

   *   Operators/Operations

MPE/iX 5.0 Documentation