ClassificationABC

This function returns the class number, starting with 1 (which represents Class A).

Syntax:

ClassificationABC(Value, GroupCount, PercentageForGroups, GroupName)

Parameters:

  • Value. Type: String. A value for calculating the classification. It is a string that contains an expression.
  • GroupCount. Type: Number. The number of groups for splitting.
  • PercentageForGroups. Type: Number. Sizes (percentage) of each group, except for the last one, comma-separated.
  • GroupName. Type: String. The name of the grouping for group processing calculation. 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:

ClassificationABC("Sum ([Quantity Turnover])", 3)

Next page: Other operations

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.