Use isNoValue to determine if a portion of a formula contains missing values. Missing values are represented by a double dash ( --). Use isNoValue with an IF statement to identify the data or an outcome to use if values are missing.
You can use isNoValue in two ways:
To ensure that values exist for other objects in a formula: Select a portion of the formula. Select Functions, thenLogical, and double-click IsNoValue. If isNoValue is false, then values exist for the objects that you use and the formula is valid. If isNoValue is true, then all values do not exist for the objects that you use and the formula is not valid.
To substitute another value for a missing value:Use an IF statement to specify the data to use when other values are unavailable. For example, to use 50 for a scorecard score if the score is unavailable, you could use this formula:IF(isNoValue(sScore(scorecard)), 50, sScore (“scorecard”)).
See IF Statements.