Attributes for retrieving financial model results

The results from the financial analysis of the model are returned to the attributes in the same module that contains the time grid.
If time grid values are edited in the time grid editor, the results retrieved from the financial analysis in the attributes is reset to zero. The values must be saved using the Investment analysis interface to retrieve results from the financial analysis of the model.

The values for NPV, NPV Mean, NPV Standard Deviation, ROI, IRR and Payback Period are not calculated for the read-only attributes in a view.

If the connected attributes in a view cannot be edited, those attributes are not updated when they are saved by using Investment analysis.
Important: To return the results, the alias of the time grid is used as a prefix for the alias of each result attributes. For example, if the alias of the time grid attribute was defined as TG, the alias of the result attributes must be TG__<Alias Suffix> respectively.
Table 1. Attributes to retrieve financial analysis result
Result Attribute Type Alias Example
NPV Distribution Matrix time grid alias__NPV TG__NPV
NPV Mean Float time grid alias__NPVMean TG__NPVMean
NPV Standard Deviation Float time grid alias__NPVStddev TG__NPVStddev
ROI Integer time grid alias__ROI TG__ROI
IRR Float time grid alias__IRR TG__IRR
Payback Period Integer time grid alias__paybackPeriod TG__paybackPeriod
ROI To Date Matrix time grid alias__ROIToDate TG__ROIToDate
ROI To Go Matrix time grid alias__ROIToGo TG__ROIToGo
Payback Period Distribution Matrix time grid alias__paybackPeriodDist TG__paybackPeriodDist
Note: The options Display as Line Chart and Flip Matrix Axes are good choices when configuring the matrix attribute.
After you configure the attributes to retrieve the financial results, you can build your financial model.

Feedback