Crystal Reports for Eclipse Designer Guide

Mode

Description
Identifies the most frequently occurring value.
Overloads
  • Mode (fld)
  • Mode (fld, condFld)
  • Mode (fld, condFld, cond)
  • Returns
    Fractional Number
    Action
    Identifies the most frequently occurring value.
    For example:
  • You can calculate the mode of all the values in a field.
  • You can calculate the mode of all the values in the field, within a group (for example, sales grouped by the state that they come from).
  • You can calculate the mode of all the values within a group in which grouping is controlled by changes in a date or Boolean field (for example, sales grouped by the month in which they were made).
  • Examples
    Mode({Customer.CUSTOMER NAME})
    Returns the mode (the most frequently occurring value) for the Customer Name field.
    Mode({Customer.CUSTOMER NAME}, {Customer.REGION})
    Groups values in the Customer Name field by region, and then returns the mode for the Customer Name field, per region.
    Mode({Customer.CUSTOMER NAME}, {Customer.REGION}, "monthly")
    Groups values in the Customer Name field by region, then returns the mode of the Customer Name field for each region, per month.
    Comments
    Mode works like NthMost Frequent when N = 1.
    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/