Syntax
FirstNotMissing(Expression1, Expression2, ..., ExpressionN)
Description
Return the value from the first expression that is not MissingValue (-9999). One use is when climate data could come from one of several CSV file -- this can get the first one that is non missing.
Examples
FirstNoMissing( ReadFromFile(HistoricalClimate.CSV, "Precip"),
ReadFromFile(FutureClimate.CSV, "Precip") ) = the value from
HistoricalClimate if it exists for current year and timestep, otherwise
from FutureClimate
FirstNoMissing( MissingValue, 5, 4 ) = 5
FirstNoMissing( MissingValue, MissingValue ) = MissingValue