Equation Format
I need to pull a value from an equation I use in excel and I am not sure how to correctly format it in Podio Calc fields.
The app has an input field "Turnover" this value needs to replace "X" in the following
((−4.5799×10^−11)×(X^2))+(0.0000044233×X)+36.322
This works easy in excel but I cannot figure out the correct way to use it in Podio/Java

Hi Stuart,
if I remember right, ^ means in your example: X to the power of 2 (X²).
In Javascript 10^2 = 8
For "to the power of" you have to use Math.pow(X,2)var X = @turnover; var y= Math.pow(10,11); var z = Math.pow(X,2); ((4.5799*y)*(z))+(0.0000044233*X)+36.322
Take care that you use the right minus sign:  , not −
Rainer
Please sign in to leave a comment.
Comments
4 comments