IRR Function with Row values

Hello All,

I want to use Finance.IRR() function.
The Format mentioned in BIRT is IRR(range,intrate), when i tried the IRR function in excel its formula is IRR(row1:row15) i.e values of row1 to row15.
The problem I am facing is that the rows (i.e row1 to row15 are calculated fields in my table's footer in BIRT 2.3.2.1).
So how to take these values in range format. i.e
for example:
Finance.IRR(row["val1"], row["val2"]...row["val15"]),2)

I tried the above solution but i dont get the required result.

please reply your suggestion.

Thanks in advance...

With Regards,
Vishal KP.

Find more posts tagged with

Comments

vishalkp

Hello All,

Actually i am want to pass the row["val1"] to row["val15"] as range to IRR function as done excel.
But when i do in the same way as in excel then i get error as script engineering wrapped.
The values of each row["val1"] to row["val15"] are calculated values and not taken from the dataset.
please do provide any solution.

Thanks,

Vishal KP.