Contents
- Index
- Previous
- Next
Matrix Expressions
You may enter three types of matrix expressions; a value expression, hint expression and filter expression.
A matrix value expression is a mathematical equation that returns a numeric result. The result is displayed in the matrix table. A matrix hint expression is also a mathematical equation that returns a numeric result, with the result displayed as a hint as you move the mouse over the matrix cells. A matrix filter expression is an equation that returns a logical result (true or false). If the matrix value does not meet the matrix filter expression, then the matrix cell displays a zero (0).
When you add or edit any of the matrix expressions, you should press F5 to recalculate the matrix and display the new results.
A matrix expression consists of a set of operators, functions and keywords.
Some example matrix calculations are as follows:
(mf1 / 100) + (mf2 / 100)
random * mf1
trunc(mf1 / 10)
While the matrix table displays the result of a matrix calculation, this result does not replace the contents of the selected matrix unless you explicitly save the matrix calculation. To save a matrix calculation, either click the Save Calculation button on the Matrix Toolbar or right-click the matrix and choose the Save Calculations... menu command.
A filter expression is a mathematical equation that returns a logical result. A matrix filter highlights cells that meet the filter expression. In this example, only cells where the matrix value is greater than 10 are shown. While the remainder of the matrix cells are still displayed, the unused table cell color is used to indicate that these cells do not meet the filter expression. This color can be changed using the Preferences form.
If you select an origin or destination ensemble, then only those cells that meet the filter expression are accumulated to the grouped cells.