Crystal Reports for Eclipse Designer Guide

NthLargest

Description
Determines the Nth largest value in a given field, either for the entire report or for each instance of the (condFld) group.
Overloads
  • NthLargest (N, fld)
  • NthLargest (N, fld, condFld)
  • NthLargest (N, fld, condFld, cond)
  • Returns
    Fractional Number
    Action
    Determines the Nth largest value in a given field, either for the entire report or for each instance of the (condFld) group.
    Examples
    NthLargest(1, {Customer.CUSTOMER ID}
    Returns 50, where the Customer ID field contains numerical values ranging from 12 to 50.
    NthLargest(5, {Customer.CUSTOMER NAME}, {Customer.REGION})
    Returns the fifth largest value in the Customer Name field, per region.
    NthLargest(1, {orders.ORDER AMOUNT}, {Customer.REGION}, "monthly")
    Groups values in the Amount field by region, then returns the largest value in the Amount field for each region, per month.
    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/