Forum Discussion

palunel's avatar
palunel
Icon for Helper I rankHelper I
9 years ago
Solved

XNPV gives same result for 2 different time series

I have 2 different time series of 8400 values.  As per the figure below:         However the calculation of XNPV is exactly the same for both series as shown in teh figure.  The code for b...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago
    Hi palunel,

    Looking at your measure both ones are pointing to the TOTAL[Scenario3] althought the time set are from scenario 1 and 3 shouldn't they be for different totals also

    MFelix
MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago
Hi palunel,

Looking at your measure both ones are pointing to the TOTAL[Scenario3] althought the time set are from scenario 1 and 3 shouldn't they be for different totals also

MFelix
palunel's avatar
palunel
Icon for Helper I rankHelper I
9 years ago
MFelix wrote:
Hi palunel,

Looking at your measure both ones are pointing to the TOTAL[Scenario3] althought the time set are from scenario 1 and 3 shouldn't they be for different totals also

MFelix

Yes, of course that's the problem.  I have been staring at it for an hour and did not see it.  Time to go to bed.

 

Thanks MFelix.

 

Paul