Page 1 of 1
PMT supported function in TM1 web
Posted: Mon Jan 07, 2013 3:42 pm
by tosca1978
Hi all,
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:
. In excel it displays the corrcet result.
However, when viewed in TM1 Web the Monthly payment calculation = #ERR!
Any advice would be much appreciated.
Kind regards
Re: PMT supported function in TM1 web
Posted: Tue Jan 08, 2013 8:08 am
by AnthonyT
Is this the same as PAYMT ?
Re: PMT supported function in TM1 web
Posted: Tue Jan 08, 2013 10:47 am
by tosca1978
AnthonyT wrote:Is this the same as PAYMT ?
I'm not sure what PAYMT is - is it an excel function or TM1 function? I can't find it in either. PMT calcuates the monthly payment on a loan...
Re: PMT supported function in TM1 web
Posted: Tue Jan 08, 2013 1:15 pm
by AnthonyT
From the reference documentation
This is a TM1® rules function, valid in both TM1 rules and TurboIntegrator processes.
PAYMT returns the payment amount of an annuity based on a given initial value or principal, an interest rate, and a number of periods. An annuity is a series of payments made at equal intervals of time.
Syntax
PAYMT(principal, interest, periods)
Not sure if this is the function you were looking for
Re: PMT supported function in TM1 web
Posted: Tue Jan 08, 2013 2:40 pm
by tosca1978
AnthonyT wrote:From the reference documentation
This is a TM1® rules function, valid in both TM1 rules and TurboIntegrator processes.
PAYMT returns the payment amount of an annuity based on a given initial value or principal, an interest rate, and a number of periods. An annuity is a series of payments made at equal intervals of time.
Syntax
PAYMT(principal, interest, periods)
Not sure if this is the function you were looking for
Anthony,
Apologies I was searching for PAMT in the devleopers guide when I said that I couldn't find it. I've had a read and it looks like this may be able to help me, so many thanks. Still not sure why PMT doesn't work but I have logged this with IBM.
Thanks again.
Re: PMT supported function in TM1 web
Posted: Wed Jul 16, 2014 9:39 am
by tm1learn
helo,
how about the interest rate formula?
in excel we use =rate(nper,pmt,pv) but when i try this formula in tm1, it cant.
can anyone help me to fixed this problem??
thanks