Invalid Expression Results
Calculated columns can be used like any other data column, but unlike normal data columns, they can cause invalid numeric values (for example, NaN (Not a Number) due to the log of zero or negative numbers or infinity, because of zero divides or other numeric calculations).
After you have defined a calculated column, Supervisor goes through all existing data (rows) to determine if the expression has any invalid results. If any invalid results are found, they are reported with a red background in the Load Summary Window, and the column cannot be used for any analysis or graphing until either the underlying data is fixed (which may include setting Data Filters to remove the values that cause the problem), or the calculated column's expression is changed.
Note: Where one or more of the data columns used in the expression have missing values, the dependent calculated column has a missing value.
View Invalid Expressions
- Add Calculated Columns.
- Open the Load Summary Window.
- Highlight the rows of the Load Summary Table with any errors that are highlighted in red.
The error details display in the table at the bottom of the Load Summary Window.
- Navigate to the Filter and Data Window to view individual data point errors.
- In the Configure the Filter and Data Tab check Show Data to display the Data Table.
- Assess the error values highlighted in yellow in the Data Table.
- Address the errors by using Data Filters or other methods.