Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Content

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

Regards

Philipp

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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