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:
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
- The topic ‘Can't make mathematical form work’ is closed to new replies.