I have another question about the POW function.
Can this pow function do complicated mathematical formulas?
I need to calculate this:
PMT * [ ( ( 1 + i )^N – 1 ) / i ]
I doesn’t work when i put it in a calculate field like this:
(((POW(1+fieldname1,fieldname4)-1)/fieldname1)*fieldname2)
So my question is: how can i calculate this right?
( 1 + i )^N