I am trying to calculate mortgage payments in Podio. The formula is P=((r(1+r)^n)/((1+r)^n-1)). My issue is Podio will not raise to a certain power. I have a field number of units = 10. When I input @number of units^2 the result is 8. When I change the 2 to a 5, it equals 15. Does anyone have a workaround for this? Also, is there a better way to calculate mortgage payments? Thank you.
Please sign in to leave a comment.