Moving Average Functions NANUM (Missing value) Ignore or Zero Issues


Version: 2021

Type: Features

Category: Analysis

Subcategory: General

Jira: ORG-22170


Support different ways to treat missing value in the following functions: movavg, tmovavg and movcoef.

New option “missing“ is introduced:

  • 0: omit missing values from the calculation by default which is same as before

  • 1. include missing values in the calculation

  • 2. omit missing values from the calculation, but keep missing in the output