Crystal Reports for Eclipse Designer Guide

Average

Description
Enables you to average the values that appear in your report.
Overloads
  • Average (fld)
  • Average (fld, condFld)
  • Average (fld, condFld, cond)
  • Average (x)
  • Returns
    Number
    Action
    Enables you to average the values that appear in your report. For example:
  • If a sales report includes a field that shows the amount of each order, you can compute the average of all the orders that appear on the report (a grand total average).
  • If you break orders into groups (for example, orders grouped by the state that they come from), you can compute the average order per group (in this case, per state).
  • If you break orders into date or Boolean groups (for example, orders grouped by the month in which they were placed), you can compute the average order per group based on a particular change in the date or Boolean field (in this case, per month).
  • If you specify an array of individual values, you can also compute the average value in the set. For information on this kind of summary, see Array summary functions.
  • Examples
    Average({orders.ORDER AMOUNT})
    Calculates the average of all values in the Amount field.
    Average ({orders.ORDER AMOUNT}, {customer.CUSTOMER ID})
    Finds the average amount of a sale made to each customer.
    Average ([10,12,32,48])
    Calculates the average of the values in an array of constants.
    Using this function in a formula forces the formula to be evaluated at print time. For more information on evaluation time considerations, see Evaluation Time.



    SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/