TM1 Forum

oke i got it,
but the reference guide just tell me that paymt function like this
=PAYMT(principal, interest, periods)

there is no the difference calculation between the advanced and arrear..

how could i know to calculate the paymt in tm1 with the advanced and arrear?

where's the refference guide?
in excel we can use the function to calculate the payment loan with advanced and arrear..
but how to know the advanced and arrear?

i'm use office 2010 and controller 10.2

periode 5
rate 12%
pv 100000000

Does anyone know how to calculate the pmt funtion, if we are using the pmt function in excel, we will input =pmt(rate,nper,pv,fv,type) the type is 0 for end of the period and 1 for begining of the period) but how to using the pmt function in tm1? and what is the difference if i using the pmt with ad...

Dear All,

i just installed tm1 client 10.2 with windows 7 64bit, on the architect options and the admin host i input my server name,
and the server is readable, but when i click the server, want to login it stuck, and the architect becoming not responding.

how to solve this ??

i'm so sorry for the post

by the way, how to solve this ?

Dear all
i know, that tm1 looks like an excel, but can the tm1 use whatif analysis datatable like excel?,
if it can, can anyone help me and guide me ??

and how about the interest rate formula?
in excel we use =rate(nper,pmt,pv) but when i try this formula in tm1, it cant.


thanks

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

Dear all, how to calculate the interest rate in tm1? if we use excel, the formula is (=rate(nper,pmt,pv).. but when i try use this formula in tm1, it cannot.. i have 2 dimensions,(dim a and dim b) dim a have 4 elements, such as -present value -periode -pmt (use paymt formula) -rate and dim b just fo...