Show TOC
# FIX Operator and Restricted Key Figures

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:

- The basic key figure is Sales again.
- The second key figure is the restricted key figure Sales (Product A), restricted to product "A".
- The third key figure is the restricted key figure Sales (Product A, Product B), restricted to the products "A" and "B".
- The fourth key figure is calculated using a formula: Sales (Product A) / Sales (Product A, Product B) with Exception Aggregation SUM by Product.

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 |

The formula that the analytic manager executes is as follows:

SUM( Sales (Product A)/ Sales (Product A, Product B) ) by Product

Incorporating the FIX operator, this formula is:

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.