Search
Nov 25, 2018

Do exponents work ? :(

7 comments58 views

Hello everyone!

Something is bothering for hours now and I can't figure out what's wrong. As wix code doesn't have the pow() function I assumed we could use " ^ " but it seems like it doesn't work...

I'm trying to make a basique tool to transform annual rates into monthly rates. Here is a piece of the code, if someone has a clue on how to do that...

//growth from year n to n+1

var Aug1

//current year's profit

var Rn

//next year's profit var Rn1

...

Rn=$w('#input6').value Rn1=$w('#input7').value

Aug1=(Rn1/Rn-1)*100

...

$w('#slider15').value=Aug1

//monthly growth needed to get the second year's profit

$w('#slider17').value= ((1+Aug1/100)^(1/12))-1

Many thanks in advance !

PS : currently for a growth of 100% in 12 months it says it's 1% per month...

Nov 25, 2018

I'm guessing it's doing integer math; does replacing the following line:

 $w('#slider17'#slider17').value= ((1+Aug1/100)^(1/12))-1

with the following line:

 $w('#slider17'#slider17').value = ((1 + parseFloat(Aug1 / 100)) ^ parseFloat(1 / 12)) - 1

make it work for you?

Nov 25, 2018

Hey!

First of all thank's a lot for your answer!

But it doesn't work, the result still has nothing to do with the reality...

Nov 25, 2018

@Paul Grillet - I think @abergquist is on the right track but I think applied the solution to the wrong statements ;-)

I think you need to check the types you have set your input values to. Are they Numbers or are they Text? Text will not allow you to do math the way you are expecting.

You can check in the console when in preview mode by adding this below your assignments to Rn and Rn1.

Rn=$w('#input6'#input6').value
Rn1=$w('#input7'#input7').value
console.log("Rn type is: "+typeof Rn);
console.log("Rn type is: "+typeof Rn1);

If these log statements tell you that you are using Strings then you can use the parseFloat() function to force the values to be floatingPoint (see below) OR you can change the types in the Editor. Also note that if an Integer is added in the input field then your assignment may still need parsed to a float. Experiment and see what happens!

Rn= parseFloat($w('#input6'#input6').value)
Rn1= parseFloat($w('#input7'#input7').value)

console.log("Rn type is: "+typeof Rn);
console.log("Rn type is: "+typeof Rn1);

If you are using numbers something else may be happening. If you share a link to the page you are having problems with it will be easier to give you some help.

Steve

Nov 25, 2018

HI Steve!

I checked and all the inputs are numbers, however I tried your method and I did not work either. I tried to break down every part of the process to see where the issue is and it seems like the exponent is the problem...

I tried with the following :

Rn = 100

Rn1 = 200

// expected results: growth = 100% and monthly growth = 5.9%

A = (1 + (Aug1/100))

//expected result: 2, it's ok

B = A^(1/12) //expected result: 1.059 but the result is 2 & same result it I try with A^(0.0833333)

C = (B-1)*100

//as B doesn't work C can't work either

If you want to try yourself here is the link, it's in french but I translated the important parts in the red square so it's easier for you : https://www.qualicontent.com/calcul-d-objectifs

Nov 25, 2018
Best Answer

Alright I figured it out, in case someone has the same issue, we just need to use ' ** ' instead of '^ '!

So many hours of my life wasted haha

Thank's Steve Cropper and abergquist for your help !

Nov 25, 2018

Thanks, Paul.

So it sounds like the following works for you:

 $w('#slider17'#slider17').value = ((1 + (Aug1 / 100)) ** (1 / 12)) - 1

If that's the case, then the following should also work for you:

 $w('#slider17'#slider17').value = Math.pow(1 + (Aug1 / 100), 1 / 12) - 1

(The latter solution involves fewer parentheses, too.)

Log In to Comment
Get in on the conversation.
Sign Up Today
Not a member yet? Join our community to post and comment.