You can use the MatrixIRR business rule to calculate the IRR by using the values in a matrix. The result is displayed in the business rule container attribute. If the values in the row change, the IRR is automatically updated.
Prerequisites
▪ A matrix attribute that triggers the business rule.
▪ A business rule container to enter the business rule.
Format
In the business rule container attribute for an element, enter the business rule in the following format:
=MatrixIRR('MatrixAttribute(CELLSPAN)')
Parameters
Parameter
Description
MatrixAttribute
The matrix attribute on which the business rule is triggered.
CELLSPAN
The range of the cells for a row in a matrix. For example, A1:C1.
Example
From a Financial matrix attribute, to calculate the IRR for a matrix that spans the cells that spans from A10 to D12, use the following expression: =MatrixIRR('Financial(A10:D12)')