ABC
Syntax
<abc-expression> := 'ABC(' <Key> ',' <Number> ',' <Number> ',' <Number> ')'
Since
2.1
Return-type
Key
Description
The ABC functions helps building an ABC-analysis. With this function you can analyze keys by any fact and find the keys with the (summarized) N% of the fact.
The first argument determines the list of keys you want to group. The second arguments is the formula you want to apply on the keys (usually a simple fact). The third and fourth arguments set the boundaries (maximum as first and minimum as second percentage, expected as values between 0.0 and 1.0) of the group you want to extract from the keys.
If any of the arguments is NULL the function will return NULL.
Examples
ABC( LEVEL( Products, 1 ), Amount(), 1.0, 0.5 )
Find the Products with the top 50% amounts in sum
