Calculate Cashflow on the basis of IRR set by the user
In Excel we have Goal Seek function to set Target value of a calculated cell and based on that target value, excel performs reverse calculations and gives source value needed to achieve the target. Now, in Anaplan I want to achieve this similar functionality.
IRR is an Anaplan function resulting in value calculated from cashflows with respect to time. This result is stored in a line item without any dimensions.
Is there any way where end user can set target value for IRR and cashflow is calculated accordingly performing reverse calculations? (For a single cell)