Help Topics

Expression tab


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 minus Expenses

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:

Insert a function
Insert a function
Inserts a function into the expression.
Insert a member
Insert a member
Inserts a member into the expression.
Edit an existing member or function
Edit an existing member or function
Edits the member or function that the cursor is currently in.
Plus
Plus
Inserts the addition operator.
Minus
Minus
Inserts the subtraction operator.
Multiply
Multiply
Inserts the multiplication operator.
Divide
Divide
Inserts the division operator.
Add parentheses
Add parentheses
Inserts left and right parentheses.
Validate the expression
Validate the expression
Determines if the expression's syntax is valid.

After you form the expression, you can validate it or edit the members and functions that the expression contains.

 

Related topics: