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.

berekenhulp

(@berekenhulp)

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.

berekenhulp

(@berekenhulp)

Thanks! I didn’t think of this solution. Great ðŸ™‚

berekenhulp

(@berekenhulp)

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

• 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.

berekenhulp

(@berekenhulp)

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.