The following is an example without constant selection and serves to show that the FIX operator can also be used in cases like this.
Working without constant selection offers no benefits however, as you obtain the same results as you would have without the FIX operator.
The following example has the following key figures:
Product | Sales | Sales (Product A) | Sales (Product A, Product B) | Sales (Product A) / Sales (Product A, Product B) by Product |
---|---|---|---|---|
A | EUR 450 | EUR 450 | EUR 450 | 1 |
B | EUR 1200 | EUR 1200 | ||
Total | EUR 1650 | EUR 450 | EUR 1650 | 1 |
SUM( Sales (Product A)/ Sales (Product A, Product B) ) by Product
SUM( Sales (Product A)/FIX( Sales (Product A, Product B) ) ) by Product
Product | Sales | Sales (Product A) | Sales (Product A, Product B) | SUM( Sales (Product A)/FIX( Sales (Product A, Product B) ) ) by Product |
---|---|---|---|---|
A | EUR 450 | EUR 450 | EUR 450 | 1 |
B | EUR 1200 | EUR 1200 | ||
Total | EUR 1650 | EUR 450 | EUR 1650 | 0,27 |
The FIX operator causes Sales (Product A) / Sales (Product A, Product B) to be aggregated with the standard aggregation, as there is no exception aggregation defined in the inner formula. As the FIX operator removes the GROUP-BY clause for Product, the entire formula exception aggregation by product is omitted. The calculation therefore has the same result as it would if no exception aggregation had been defined in the formula.