I am using TM1 v10.1 and excel 2007.
In the cognos TM1 Developer Guide\Supported Excel Functions - TM1 Web - Finance Functions: it states that the PMT function is supported. However it doesn't seem to be working for me.
I have created a TM1 worksheet containing the following:
Loan Value
Loan Rate
Loan Term
Monthly payment
I have hard coded values against the first three and put the following formula against Monthly payment:
Code: Select all
=PMT(G8,G9,G7)
However, when viewed in TM1 Web the Monthly payment calculation = #ERR!
Any advice would be much appreciated.
Kind regards