Discussion Board for collaboration related to QlikView App Development.
I am trying to do a simple IRR function that you feed some monthly cashflows in date order. I am comparing this to Excel and the results are quite different.
The function that I'm using is :
in Qlik and
= (1+IRR(D2:D481, 0))^(12)-1
Can anyone advise why I might be getting different answers? FYI, it seems that Excel is CORRECT!
Go to Solution.
Turns out that the cashflows needed to be loaded into the app in the correct order (rather than just sorted once in)... values seem to match now! Thanks everyone.
View solution in original post
I am not getting different results between excel and qlikview, could it be a rounding error?
Only time I've had issue cropping up with IRR has been when the first value hasn't been a negative