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

Projected 12 does not skip none when calculating the average

edited Oct 18, 2021 2:53AM in Planning 1 comment

Summary:

Projected 12 does not skip none when calculating the average in rolling forecast

Content (required):

Hi

Im using projected 12 to calculate the sum of current month +11 future periods.


For account members with time balance property of average, it gives the average of current month + 11 future period values. (and i have to put to SKIP NONE)

so when all 12 month values are there, projected 12 calculates accurately the average (PFA)

But when some months values are missing, it does no accurately calculates the average by skipping NONE.

Anybody had this issue

(PFA)


Version (include the version you are using, if applicable):

21.10.67

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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