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