NPV Function cannot get what has been provided in the technical document

Ivan_Lo_

Hi all,

 

I tried to replicate the example in the Anapedia link

However, I cannot get the same result as in the example as below.

  

 

My module as below, my result as highlighted.

Even the same cash flow data, same date column, and same formula with hardcoded discount rate. 

 

What do I miss? any idea?

 

Thanks.

Misbah

@Ivan_Lo_ 

 

You are missing Lease dimension in your target module

 

Hope that helps

Misbah

Miz Logix

Ivan_Lo_

Thanks Misbah!