Troubleshooting
Problem
The IRR formula in Excel returns #NUM! in a websheet in TM1 Web when the result is negative.
Resolving The Problem
To workaround this issue, include an optional guess parameter of "-.1" in Excel. The IRR function starts with the guess and iterates until the result is accurate.
For example: IRR(E3:E5, -.1)
For more information, see IRR Function in Microsoft Excel documentation.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Component":"TM1 Web","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.0.6","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
06 September 2019
UID
ibm11072916