Support » Plugin: Calculated Fields Form » POW Equations

  • Resolved berekenhulp

    (@berekenhulp)


    According to the CFF documentation, the POW equations has to be like this: pow(x,y).
    Is it possible to use it with a single variable, like this: pow(x)?

    For example, the SQRT is possible with a single variable, like this: sqrt(x).

    Thanks for your help!

    • This topic was modified 1 year, 7 months ago by  berekenhulp.
    • This topic was modified 1 year, 7 months ago by  berekenhulp.
Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @berekenhulp,

    The “POW” operation requires two parameters, but these parameters can be numbers, for example:

    POW(fieldname1, 2)

    Best regards.

    But why does it require 2 fields? I’m looking for something that works like square.
    For example:
    SQR(2) = 4
    SQR(3) = 9

    Plugin Author codepeople

    (@codepeople)

    Hello @berekenhulp,

    Because our plugin does not include a SQR operation. I don’t understand the problem of using:

    POW(2,2) = 4
    POW(3,2) = 9

    Best regards.

    Thanks! I didn’t think of this solution. Great 🙂

    When i’m using the POW equation in my formula it doesn’t work.

    My question: I would like to calculate my final capital with the following conditions: monthly investment of €300, yearly interest rate of 7% and a duration of 20 years. I use the following formula:

    Fieldname2/
    (1-POW((1+fieldname4/100),(1/12)))
    +
    (fieldname2-fieldname2/(1-POW((1+fieldname4/100),(1/12))))
    *
    POW((1+fieldname4),fieldname3)-fieldname2

    I don’t get any result but it should be 153121,8183

    Fieldname 2 = monthly investment
    Fieldname 3 = duration in years
    Fieldname 4 = yearly interest rate

    Can you please help me? Thanks in advance

    • This reply was modified 1 year, 6 months ago by  berekenhulp.
    Plugin Author codepeople

    (@codepeople)

    Hello @berekenhulp,

    Could you send me the link to your webpage for checking the form in action, please?

    I’ve tested the formula your are referring:

    fieldname2/(1-POW((1+fieldname4/100),(1/12)))+(fieldname2-fieldname2/(1-POW((1+fieldname4/100),(1/12))))*POW((1+fieldname4),fieldname3)-fieldname2

    replacing the fields’ names with the corresponding values:

    300/(1-POW((1+7/100),(1/12)))+(300-300/(1-POW((1+7/100),(1/12))))*POW((1+7),20)-300 =

    6.151806564773718e+22

    Now using pure javascript, without our plugin’s operations:

    300/(1-Math.pow((1+7/100),(1/12)))+(300-300/(1-Math.pow((1+7/100),(1/12))))*Math.pow((1+7),20)-300 =

    6.151806564773718e+22

    As you can see the result was just the same.

    Best regards.

    Wow! So much thanks for your response

    But when I’m using MS Excel, using the formula beneath, it gives another result.

    B2/1(1-(1+B4/100)^(1/12))+(B2-B2/(1-(1+B4/100)^(1/12)))*(1+B#/100)^B3-B2 = 153121,8183

    B2 = monthly investment
    B3 = duration in years
    B4 = yearly interest rate

    I don’t understand the problem. Can you please help me out?

    Plugin Author codepeople

    (@codepeople)

    Hello,

    The difference is simple, in your Excel formular you are using

    *(1+B4/100)^B3-B2

    but in the equation:

    *POW((1+fieldname4),fieldname3)-fieldname2

    In the Excel formula you are dividing B4/100 but not in the equation.

    I’m sorry but debugging the users equations is not covered by the support service. If you need additional help implementing the equations, you should request a custom coding service:

    https://cff.dwbooster.com/customization

    Best regards.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘POW Equations’ is closed to new replies.