RANK

Returns rank of the values displayed in the rows and belonging to the specified control. For example, if there are 5 rows belonging to the Order_DetailsTableControlRow containing values for UnitPrice control as 57, 32, 12, 19, and 98 then the rank for the number 57 is 4, which is its position after arranging the values in ascending order. This function is called as <RecordControlName>.RANK("<ControlName>"). Use a RecordControl instance to indicate which RecordControl contains the values to be operated on by the function (e.g., Order_DetailsTableControlRow, ProductsTableControlRow, CategoriesTableControlRow).

Syntax

= <RecordControlName>.RANK(controlName)

Parameters

controlName

It represents the name of the control which contains the values whose rank is to be calculated for the specified record. The controlName should be a string (e.g., “UnitPrice”, “Quantity”, “Discount”). The values in the control can be an integer (e.g., 37), a decimal value (e.g., 37.48), a string.

Return Type

Decimal

Examples

Example

Returns

= ProductsTableControlRow.RANK(“UnitPrice”)

The rank of the values in the “UnitPrice” control which belongs to the ProductsTableControlRow.

= Order_DetailsTableControlRow.RANK(“Quantity”)

The rank of the values in the “Quantity” control which belongs to the Order_DetailsTableControlRow.

= CategoriesTableControlRow. RANK (“Discount”)

The rank of the values in the “Discount” control which belongs to the CategoriesTableControlRow.