TM1

TM1 Rule-based Approach for Internal Rate of Return (IRR)

TM1 does not offer a native IRR function. After three years of on-again/off-again thinking through and researching online how to construct a proper TM1 rule-based IRR calculation, I’ve built this methodology which has been used in a production environment for several years.

RunProcess in PAFE

You can use the ExecuteFunction PAX API method to execute a TI process using Excel VBA. There are several limitations. I took the challenge and created my own RunProcess subroutine to solve for these limitations.

Scroll to Top