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.

Have you checked all the financial functions:

https://fmhelp.filemaker.com/help/16/fmp/en/#page/FMP_Help/financial-functions.html

In addition there may be custom functions that use these or expand on these. Two common sites posting many of these:

http://www.fmfunctions.com/

http://www.briandunning.com/filemaker-custom-functions/

Perhaps plug-ins go further where the above are not sufficient?

Another recent similar thread on this forum:

https://community.filemaker.com/thread/178068

Beverly