Time Balance Property Average
We have accounts where we would like to have the average (of the period values) calculated in Quarter or YearTotal. If we select the Time Balance Property "Average", this works.
However, if we display Q2 or YearTotal, it is divided by all corresponding periods (i.e. divided by 3 for quarters and divided by 12 for YearTotal, regardless of whether values are available or not).
We expect that it is only divided by months in which data is available.
Is there an uncomplicated workaround?