Hi @wpidl
I hope you’re well today!
Forminator doesn’t have built-in support for PMT function.
I’m not much of an Excel user and am not familiar with this kind of calculation but Google search responds that the actual calculation behind the PMT function is:
P = (Pv*R) / [1 – (1 + R)^(-n)]
This operands (except for square brackets) seem to be all supported so assuming you substitute values of above equation with relevant form fields, you can do this:
– add one calculation field (let’s say it’s calculation-1)with this calculation only
1 – (1 + R)^(-n)
– and add another calculation field (let’s say it’s calculation-2) with this calculation then
(Pv*R) / {calculation-1}
As a result, calculation-2 should give you result just like PMT function, if I correctly understand it.
However, note please that I cannot take responsibility for that and you would need to test it thoroughly first to make sure it actually does work correctly. It seems it should be you’d need to confirm that before using it on a live site.
Kind regards,
Adam
