The Calculated Facts page is used to set formulas for calculated facts. Calculated facts is a function from values of other facts, calculated facts or relations.
All cube facts are displayed on this page:
/ - facts that are bound to data set fields.
/ - facts that are not bound to data set fields. A formula, by which values can be calculated, can be determined for them. After setting a formula fact icons change for /.
To display data cube facts, click the Show Data Facts button.
To hide data cube facts, click the Hide Data Facts button.
Formulas can be set up using the expression editor:
The expression editor in the desktop application is uniform for all platform tools and objects. Description of the uniform expression editor is given in the Creating Formulas and Expressions document.
The expression editor in the web application differs depending on the configured tool or object.
The expression editor window for setting up calculated facts of standard cube in the web application looks as follows:
Create a formula, by which the calculated fact will be calculated.
Operands, arithmetic operations, functions, numbers, comparison characters and round brackets can be used in a formula. There are some features of use:
All element types, except for numbers, can be inserted both using the keyboard or special panels.
Numbers are inserted only using the keyboard.
Insert functions and operators
See also: