We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

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


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

Content (required):


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


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


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

Howdy, Stranger!

Log In

To view full details, sign in.


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