Skip navigation

Average Only Non Zero Values, Ignore Zeros

score 8
You have not voted. Active

The data I receive from third parties sometimes display zeros for where information is not available. This is usually when time series data is not available for certain dates. However, by doing this it effects averaging. The only way to get around this is by creating a calculation for each measure by replacing zeros with nulls which can be a problem when there are numerous measures. I rather not have to adjust the raw data in case this adjustment is done incorrectly.