Hi.

I am having a problem with making my mathematical formula "work".

I am making a formula of a simple future value calculation.

The formula is: **Present value * (1 + interest/100)^number of time periods.**

I have entered this formula in my calculated field:

**PREC(POW(fieldname4*(1+fieldname2/100),fieldname3),2)**

Fieldname 4 is present value

Fieldname 2 is interest

Fieldname 3 is number of time periods

If i for example enter 100 in present value, 2 in interest, and 20 in time periods i get a huge number compared to the real answer which should be 148.59