Hi all, I hope someone can help me, because I'm currently struggeling with a particular use case. I'm creating an extrapolation for a client, and they want to use a combination of 3 extrapolation methods: Month on Month (MoM), Year on Year (YoY) and a Manual Run Rate (Manual). Each of these methods are given a weight, which will determine what the end result should be (e.g. 50% MoM, 30% YoY and 20% Manual). MoM is going ok, and is working as intended. The YoY uses a monthly delta and then increases/decreases the final end resul of 1 year ago with this delta, which is also going fine. Due to the lagged data used Anaplan accepts this. The issue lies with the Manual part. This method uses a way to get to the End of year Runrate, which gives a baseline for the extrapolation. But then it uses a part of the YoY. It gives an additional weight to the YoY result (already calculated) and then looks for the difference of that month's value of the YoY and the average YoY result of the corresponding year. It will then add/detract this result from the baseline. To give an example for this last part: YoY: 100, 100, 50, 100, 150 Difference to average 0, 0, -50, 0, 50 Baseline of Manual 125, 120, 100, 120, 125 Manual end result 125, 120, 50, 120, 175 But when I try to calculate the average of the year using an average as summary and a lookup it will give me a circular reference error. I hope that someone can help me. Cheers, René
... View more
