Rank

Syntax:

Rank(Order, HierarchyOrder, GroupName)

Parameters:

  • Order. Type: String. Contains expressions for ordering comma-separated group records. You can set the order direction by using the words Asc and Desc. You can add AutoOrder after the field, which means that the ordering fields defined for the referred object are used for ordering references. If the order is not specified, the value is calculated based on the grouping.
  • HierarchyOrder. Type: String. Contains expressions for ordering hierarchical records.
  • GroupName. Type: String. The name of the grouping where group processing is calculated. The calculation is performed in the current group if none is specified. If calculation is performed on a table and the parameter includes a null string or is blank, the value is calculated for the row grouping. When the data composition template is generated, the template composer replaces this name with the grouping name in the resulting template. If the grouping is not available, the function is replaced with NULL.

Example:

Rank("[Quantity Turnover]")

Next page: ClassificationABC

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.