cmj

Nper in Filemaker

Discussion created by cmj on Dec 31, 2017
Latest reply on Jan 2, 2018 by fmpdude

In excel, there's a function that calculates the number of payment periods for a loan: Nper(Interest/12, Payment Amount, Total Loan Amount).

I have not seen any functions in FM that calculate periods. I have researched Nper to try and find how it works mathematically and came up without anything insightful.

Has anyone else run into a workaround this?

Thank you.

Outcomes