Hi there, I would like to know how Mendix deals with financial calculators within the framework without calling a webservice or any other interface in order to get a calculation. Currently, all the calculations are done in Excel, but I prefer not to use an interface to call Excel Services. For example how would you calculate loan payment in Mendix which contains for example to the power of -n?

asked

Fedor Klinkenberg

3 answers

6

Um... pow(base, n) is a function that can be used in variables, so no need for java there. For calculating a square root you can use pow(base, 0.5).

answered

Jaap Pulleman

4

Hmm seems no power function available. Just create a simple Java action for it, this should do the trick (and file a feature request to allow it in MF expressions):