Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Time Balance Property Average — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Time Balance Property Average

Accepted answer
edited Jun 4, 2021 7:49AM in Planning 3 comments


Hello all,

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?

Many thanks



Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!