8 Replies Latest reply on Nov 28, 2015 3:14 AM by hjgunn@mmedia.is

    [XPOST]How to program Newton / Raphes in Filemaker?


      At this time I have created a solution that uses the bisection method to calculate the EARP of a loan.

      This method takes about 35 iterations to come up with an answer.


      So I would like to do these calculations using either the Newton / Raphes method or one of the Quasi Newton methods.

      I believe those methods use around 5 iterations to come up with a fairly accurate solution.


      Is there anyone here that has done this in Filemaker or that could show me how it's done?


      Also, how can I prevent the calculation from not converging?


      Kind regards