nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using the IRR function in BIRT with a dataset

crreid13

Hi,
 
I have a dataset that returns beginning value, cash flows and an ending value and I would like to use the BIRT IRR function. How would I go about doing this? I tried Finance.irr(dataSetRow["ncf"],0.1) to no avail. Any help would be great.

Thanks

Find more posts tagged with

Comments

pricher

Hi,
 
If you want to use the Finance.irr function, keep in mind that its first argument must be an array of Doubles. So, for an array defined like this:
<pre class="_prettyXprint _lang-">
ncf = [-7500, 3000, 5000, 1200, 4000];
</pre>
The Expression will be:
<pre class="_prettyXprint _lang-">
Finance.irr(ncf, 0.1)
</pre>
If ncf is a column in your data set, another solution is to use an aggregation and define it like this: