Formula example. Skip null values to calculate the average.
This example is intended to show how you can calculate the arithmetic mean without counting zeros. Those. calculation according to this formula sums and divides sums only where there are values (ignoring zeros).
1. Is the source data line for calculating the average consumption.
2. This is the line where we apply the formula if we have a value of 0 on other objects =(%formula_a%>0)?%formula_a%:' '
When we select the summation function, empty lines will be ignored.
But you can also ignore zero using a filter.
Set the value to be ignored in the report.
