Syntax
FirstNonZero(Expression1, Expression2, ..., ExpressionN)
Description
Return the value from the first expression that is not zero and 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-zero.
Examples
FirstNonZero( ReadFromFile(HistoricalClimate.CSV, "Precip"),
ReadFromFile(FutureClimate.CSV, "Precip") ) = the value from
HistoricalClimate if it exists for current year and timestep, otherwise
from FutureClimate
FirstNonZero( 0, 0, 5, 4 ) = 5
FirstNonZero( 0, 0 ) = 0