NVL([Column],[Value]/[Column]) returns [Column] NVL([Value],[Value]) returns [Value]

The NVL function replaces Null values (NaN,0 and undef) with another value. If a column is used for the first paramater, then this function will return a column.

Examples:

  NVL(EMA(Close,12),0);#Returns a column replacing all NaN values with zero.
  NVL(EMA(Close,12),Close);#Returns a column replacing all NaN values with the closing values.
  NVL(undef,15); #returns 15

Related functions:

log , cos , exp , abs , int , sqrt , sin , atan2 , ceil , floor , log10 , IsNull , IsEqual , MinValue , MaxValue , Min , Max , Sum , Cum , Round , RoundToQuarter , RoundToTickSize