1
0
-1

Hi all,

I'm currently trying to scope out an approach where we re-invent an number of excel calculators as simple web forms / calculators.

The excel calculators we've been given have used predefined excel formula such as: PMT () and Rate () .

Is it possible to replicate these formula in Avoka (using calculation fields) without writing the full mathematical formula?

Cheers,

 Nick

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Calculations are executed in JavaScript and financial functions from Excel are not included in JavaScript but you can get versions of them for JavaScript. The included JavaScript Math functions can be found at https://developer.mozilla.org/en/docs/Web/JavaScript/Reference/Global_Objects/Math and anything further can be included in a function either in an included JavaScript file or in-lining the function inside the calculation script. When defining a function to inline use the following declaration style:

      var myFunction = function(f1,f2) {

          return f1+f2;

      }

      JavaScript implementations of Excel functions can be found on various sites, eg https://www.google.com.au/search?q=javascript+pmt+function but as with anything sources from user contributed sites such as Stack Overflow please read the comments to make sure it works as intended and test it thoroughly.

        CommentAdd your comment...