I just need a little opinion whether excel is wrong or Anaplan. See below.
So i only copied the values so there is no formula.
Excel Driver Cumulate formula it adds the Excel Source value and Excel Source Plus value. So its like Sum(Value, PLus Value).
The problem that I have is in Excel Driver when they cumulate Month 1 and Month 2 are both 25.
In Anaplan, Month 1 is 25 and Month 2 is 38 (25+13). Which one is correct the excel or Anaplan formula? I just need to get some insights on this to understand better where my formula encountered a problem.
I don't think this is so automatic. We have to make another line item to use the PREVIOUS() function instead of CUMULATE(). CUMULATE(Value) + plus Value <> PREVIOUS(Cumulate) + Value + plus Value. In this case, PREVIOUS() running sums plus Value together. That is not the desired outcome.
INCORRECT BELOW. I have to reconsider..
Now I don't clearly understand what "Excel Driver" means. If I reproduce this behavior of the function with Anaplan calculation, it may be like this. new LINE ITEM = OFFSET(Cumulate Formula, -2, 0) + OFFSET(Value, -1, Value) Cumulate Formula = new LINE ITEM + plus Value
I cannot understand why so odd way this function runs. It may be just my misunderstanding about how it works.