[ad_1]
I am working on a EMI calculator with the EMI formula that contains the exponential function. Since I am using a free version PMT option is not available in the equation. So i was trying the manual equation to provide the valid output. For example, i am using the below formula for the EMI calculation. However, it’s not working as I don’t know exactly how to use the exponential function in the Calculate field plugin.
P x R x (1+R)^N / [(1+R)^N-1]
Let’s say if I want to get the answer of the below, how can I use it in calculated field formula.
fieldname1 = 0.005
fieldname2 = 12
(1+0.005)^12
(1+fieldname1)^fieldname 2 is not working.