how to use IRR

Carmine_Caruso

I want to use the IRR and NPV function in Dataview, but the help is not clear for me.

Syntax: IRR(arrayvals,estimate)

This function returns the internal rate of return for a series of cash flows represented by the numbers in an array

But my question is :

what does mean Arrayvals ?. I created a dataview whit a cube "a", and and a formula with function IRR.

I have the year dimension and I selected 10 year.

Help tells that array is a Block :

(a,x) where “a” is a Block and “x” is a number

But looks like the function work only on the same period is calculated (Scalar , not array)

There is some one that has an example clear and exhaustive ?

How I can tell function to use array values ?

I have the same problem with NPV

Thank in advance

Helmut Heimann

Hi @Carmine_Caruso ,

there is a PDF document ("Supported Functions.pdf") in our help section on algorithms

https://help.board.com/v14/docs/en/algorithms

That explains those functions a bit further.

The arrayvals are values in a cube, the "x" can be omitted to let the system use a default of 10 % (0.1). You'd need a cube representing the values you want to analyze over time, i.e., a monthly scale.

Hope that helps,
Helmut

Carmine_Caruso

Hi, Helmut,

many thanks for your answer but I read already a document.

In my opinion the key point is to explain in board Help, how array can used in dataview.

I solved creating a dimension KPI, where I copy the cash flow movements in generic items year1:year20

Then I created a Rule,giving as range year1:year20. for both IRR and NPV

I don't know if there is an alternative way to calculate NPV and IRR, but some example could help people.

Many thanks

Carmine