Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author codepeople

    (@codepeople)

    Hi,

    You have omitted a mathematical operation in the equation, and the number of parentheses is incorrect. The correct structure for the equation would be:

    fieldname4*(fieldname9*EXP(fieldname5*fieldname3))

    Really, in the previous equation there is a couple of parentheses that are unnecessary:

    fieldname4*fieldname9*EXP(fieldname5*fieldname3)

    Best regards.

    norganics

    (@norganics)

    My calculation field is trying to find the square area of a circle but doesn’t seem to be working.
    ((fieldname2*0.5)EXP2)*3.14159
    fieldname2 is the circle diameter X 0.5 = r squared X 3.14159 (pi).
    What am I doing wrong?

    Plugin Author codepeople

    (@codepeople)

    Hi,

    The correct equation in this case would be:

    POW(fieldname2*0.5,2)*3.14159

    Best regards.

    norganics

    (@norganics)

    Awesome, thanks.

    jjop215

    (@jjop215)

    hi, help me please!!! i have this equation

    PREC((((fieldname3-fieldname6)*((((((fieldname4/100)/12)+1)(12*5))*((fieldname4/100)/12))/(((((fieldname4/100)/12)*exp(12*5))-1))))+(fieldname11+fieldname12+fieldname13),2))

    <backticks>basic the important part is (((fieldname4/100)/12)*exp(12*5))</backticks> this is a calculator of monthly payments

    and I dont know why dosent work

    Plugin Author codepeople

    (@codepeople)

    Hi,

    Please, pay attention to the piece of code:

    ((((fieldname4 / 100) / 12) + 1)(12 * 5))

    You have forgotten the mathematical operator, the correct would be:

    ((((fieldname4 / 100) / 12) + 1)*(12 * 5))

    In reality your code includes many unnecessary parenthesis, the previous code is equivalent to:

    (fieldname4 /100/12 + 1)*12 * 5

    Furthermore, you should check the value of the “fieldname4” field, because if its value is zero, your equation will include a division by zero, that is an invalid mathematical operation.

    Best regards.

    jjop215

    (@jjop215)

    Thanks, but I need the results of (fieldname4 /100/12 + 1) be exponent with (12 * 5)
    (fieldname4 /100/12 + 1)*exp(12 * 5)

    Help me please…

    jjop215

    (@jjop215)

    I’m so sorry, your right, I make this big mistake… just a little question, I try to compare the result from a excel sheet, and for example the fieldname4 is for interest (7%), so

    (7/100/12+1)*exp(12*5)

    in excel appear 1.41762526, and in my form appear 1.7108096088493868e+104, inclusive if I place

    PREC(((7/100/12+1)*EXP(12*5)),11)

    … I dont understand what I am making wrong… HELP ME!!! please help me!!!

    excel sheet

    Plugin Author codepeople

    (@codepeople)

    Hi,

    I’ve checked the equation in Excel and in the plugin, and the result is the same in both, please, visit the following link:

    https://wordpress.dwbooster.com/customdownloads/2016-03-02/screenshot.png

    Best regards.

    jjop215

    (@jjop215)

    and why the opcion PREC no provide only 11 digits???

    Plugin Author codepeople

    (@codepeople)

    Hi,

    Please, in this case use the following mathematical operation instead the “PREC”:

    ROUND( (7/100/12+1)*EXP(12*5)*100000000000)/100000000000

    Best regards.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Exponent not working’ is closed to new replies.