Representing Null Values in Summary View
When a summary cell evaluates to null, Monarch Classic displays a user-defined string to represent the null value. Null values are displayed in the Summary window when:
-
No data is available to a cell. This often occurs when a key values is displayed across, creating a two-dimensional matrix.
-
A calculation, such as standard deviation or variance, does not have enough data points to yield a valid result.
-
A ratio calculation results in division by zero.
The default string used to represent null values is "(Null)", but you can specify any string you like.
-
On the Home ribbon, select Options. The Options Window displays.
-
Select View from the Options Window ribbon to display the View Options window.
-
Enter the text string in the Display null values as box.
-
To save this string as the default for future Monarch Classic sessions, select Accept. To restore the previously saved default, click Cancel.
© 2024 Altair Engineering Inc. All Rights Reserved.