I am having trouble with the results of the NPV function in Anaplan versus that of Excel. In anaplan, I cannot control the scope of the time periods being passed into the NPV function. I am expecting a value beginning in Q2 FY18. However, the calculation returns a value beginning in Q1 FY17. My client is expecting the calculation to be the same as Excel. Any suggestions?
As you can see in the drill down, the entire timescale is being used. However, if you look at the last screenshot, Excel is only referencing specific "time periods" if you will.
... View more