Forum Discussion
Calculating plan accuracy, circular reference
Hi all I´m trying to calculate plan accuracy where I can "use" orders from +-1 week to fulfill the plan. As you can see in the image below I have 13 weeks. In those 13 weeks I have plan in column...
Hi!
I tried a measure. Check out my file please. https://datascientistbudapestcom-my.sharepoint.com/:u:/g/personal/bertalan_datascientistbudapest_com/EcwG0ZGNUCRCoj3MbGpkar8BkHBkhaVoPhKBHzZG6vRiVg?e=kidxQ2
Good try but unfortunately not what I need. I have come to the conclusion that it´s not possible (at least with my knowledge) so I´m not going to calculate it in this way. I going for a less accurate but good enough method of looking at the total period instead of focusing on each week.