In the Expression tab, specify the expression for your calculation. An expression is a collection of members, functions, and operations. For example:
Expression
Description
Sales - Expenses
Sales
minusExpenses
Sum(Product 1, Product 2, Product 3)
Sum of the three products
(Product 1 / Sum(Child(Products))) * 100
Percentage of
Product 1
over all products
If the expression includes operators (such as plus, minus, multiply, and divide) that act on missing values, the calculation fails if the Replace missing values with Zero option is not set in the General tab.
The Expression tab has a text field that contains the text string for the expression. You can either type the expression in the text field or use the buttons to insert functions, members, and operators. The Expression tab contains the following buttons:
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
After you form the expression, you can validate it or edit the members and functions that the expression contains.