Crystal Reports for Eclipse Designer Guide

PercentOfAverage

Description
Returns the percentage of records fulfilling the condition of the average.
Overloads
  • PercentOfAverage (fld, condFld)
  • PercentOfAverage (fld, condFld, cond)
  • PercentOfAverage (fld, innerCondFld, outerCondFld)
  • PercentOfAverage (fld, innerCondFld, innerCond, outerCondFld)
  • PercentOfAverage (fld, innerCondFld, outerCondFld, outerCond)
  • PercentOfAverage (fld, innerCondFld, innerCond, outerCondFld, outerCond)
  • Returns
    Number value.
    Action
    PercentOfAverage (fld, condFld) has the same effect as: 100 * Average (fld, condFld) / Average (fld). It expresses the average of the values of the field fld for the group determined by condFld as a percentage of the average of all the values of fld.
    PercentOfAverage (fld, condFld, cond) has the same effect as: 100 * Average (fld, condFld, cond) / Average (fld). The String argument cond expresses some additional information to precisely specify the grouping. For example, if condFld is a Date field, is the grouping "daily" or "weekly" or "monthly" and so on.
    PercentOfAverage (fld, innerCondFld, outerCondFld) has the same effect as: 100 * Average (fld, innerCondFld) / Average (fld, outerCondFld). It expresses the average of the values of the field fld for the group determined by innerCondFld as a percentage of the average for the group determined by outerCondFld.
    PercentOfAverage (fld, innerCondFld, innerCond, outerCondFld) has the same effect as: 100 * Average (fld, innerCondFld, innerCond) / Average (fld, outerCondFld).
    PercentOfAverage (fld, innerCondFld, outerCondFld, outerCond) has the same effect as: 100 * Average (fld, innerCondFld) / Average (fld, outerCondFld, outerCond).
    PercentOfAverage (fld, innerCondFld, innerCond, outerCondFld, outerCond) has the same effect as: 100 * Average (fld, innerCondFld, innerCond) / Average (fld, outerCondFld, outerCond)
    Comments
    This function and other percentage functions are intended to support Percentage Summary fields. The groupings supplied as arguments must actually exist in the report for the summary function call to succeed.



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