Projected 12 does not skip none when calculating the average
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):