PMT supported function in TM1 web

Post Reply
tosca1978
Posts: 101
Joined: Thu Oct 20, 2011 6:53 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007
Location: London, UK

PMT supported function in TM1 web

Post 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:

Code: Select all

=PMT(G8,G9,G7)
. 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
AnthonyT
Posts: 42
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

Re: PMT supported function in TM1 web

Post by AnthonyT »

Is this the same as PAYMT ?
Anthony

That's no moon - that's a space station
tosca1978
Posts: 101
Joined: Thu Oct 20, 2011 6:53 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007
Location: London, UK

Re: PMT supported function in TM1 web

Post 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...
AnthonyT
Posts: 42
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

Re: PMT supported function in TM1 web

Post 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
Anthony

That's no moon - that's a space station
tosca1978
Posts: 101
Joined: Thu Oct 20, 2011 6:53 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007
Location: London, UK

Re: PMT supported function in TM1 web

Post 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.
tm1learn
Posts: 8
Joined: Wed Jul 16, 2014 1:38 am
OLAP Product: Tm1
Version: 10.2
Excel Version: excel 2010

Re: PMT supported function in TM1 web

Post 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
Post Reply