Equation not working

  • Resolved writerz

    (@writerz)


    6 years ago

    Hello team,
    I am trying to build a monthly EMI loan calculator with this plugin and I have used this equation
    (fieldname2)*(fieldname7/12/100)*(1+fieldname7/12/100)^(fieldname8)/(1+fieldname7/12/100)^(fieldname8)-1

    where:
    Fieldname2 = amount of loan
    Fieldname7 = annual interest
    Fieldname8 = loan term in months

    but the result is not correct, is there any problem with the equation or anything else.

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    6 years ago

    Hello @writerz

    Javascript does not includes the “^” operator, our plugin implements the POW operation as alternative:

    2^3 = POW(2,3)

    So, your equation would be:

    
fieldname2*(fieldname7/12/100)*POW((1+fieldname7/12/100),fieldname8)/POW((1+fieldname7/12/100),fieldname8)-1

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Equation not working’ is closed to new replies.

Tags