calculate the interest rate

[tm1learn]

Dear all,

how to calculate the interest rate? in excel we use =rate(nper,pmt,pv) but when try this code in tm1, it cant

i have 1 cube and in the cube has 2 dimensions,
the 1 dimensions has
-pmt (input manualy and the value is 500)
-pv, (input manually and the value is  82,510.93)
-periods (input manually the value is 20)
-rate (want to use tm1 formula for interest rate)

when i try this in excel, i got the rate 0,33% and for 1 year it 4%,

can anyone help me to solve this? see the attachment that i've uploaded.

Thanks before

[uchow10]

I believe you can use TM1 functions in excel but not other way around. Therefore you can't use a intricate function like RATE in TM1 and expect it to work. Instead for TM1, calculations are driven by rules which are cube specific. And these rules would rely on YOU to define what the calculation is

So if you know the basic premise of the calculation i.e. +,-,%,* then you can make TM1 do the calculation for you.