Calculating IRR

[Delilah Vigil]

Has anyone had any luck caculating IRR usnig TERRAggregation_Real I was able to calculate the NPV using TERRAggregation_Real("library(FinCal);output

[Jagrata Minardi]

Greetings,

Since you are invoking the FinCal package in your NPV example, why not try FinCal::irr()

In more recent versions of Spotfire, you avoid script trust issues by creating a new Expression Function. In Spotfire 10.x, go to Data > Data Function Properties > Expression Functions. Use Function type = "Column function" and Return type = "Real". Specify a name and a function category. The script can be simply:

library(FinCal)

output