In our DP Planning Book, we have two data views Months and Weeks.
The issue that we are facing for few SKUs is that the numbers don't match between MONTHS and WEEKS data view.
In MONTHS view
Months Key Fig A
In Weeks view
WEEKS Key Fig A
Now the two views do not really add up right. So when I check my same SKU in the TECHNICAL periods in the planning book, I see the following.
In Technical Period
TECH PER Key Fig A
So I found that wherever the week splits in two months, there is a very high number which makes the Month's value out of wack. This continues till the end of forecast horizon for all weeks.
One thing to be noted here is that the value in Key Fig A is copied from another Key Figure and that KF looks good.
As I am working to resolve this issue, I wanted to know if anyone has came across the same issue. Any thoughts/suggestions are also welcomed.