Large formula and calculated result on button submit in same page

  • Resolved anilverma.pes

    (@anilvermapes)


    12 months ago

    1. I have used submit button , but how to display calculated result (calculated field) only once button is clicked (on same page or new page with prefilled form data). My scenario : Form on left side and result on right side. result value is zero and actual result to be displayed on submit button click. (is this a pro feature?)
    2. I have 3 input boxes (fieldname1,fieldname2,fieldname3) , my formula is quite big , just one part i was trying to get it work but maybe i am doing something wrong. The formula is : ((((fieldname2/fieldname3-1)-(fieldname2/fieldname3)*95)*(1.29*fieldname1)*25)*12)*3 I am entering this in the equation box but it doesn’t display anything. Probably wrong expressions. Any suggestions?

    The page I need help with: [log in to see the link]

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

    (@codepeople)

    Hello @anilvermapes,

    The equation includes unnecessary parenthesis but it is correct:

    ((fieldname2/fieldname3-1)-fieldname2/fieldname3*95)*1.29*fieldname1*25*12*3

    However, I cannot check the fields values. For example, if the fields values are not numeric or the fieldname3 value is zero, the equation will fail.

    About submitting the form and display the result directly on the page, you will need the commercial plugin version.

    Best regards.

    Thread Starter anilverma.pes

    (@anilvermapes)

    The value is numeric and not zero, can put validation for that. The parenthesis you have given results in wrong (negative values) calculation though. My formula is 8 times bigger than this, not sure if i can get it done this way.

    plugin is great but not sure if i can get desired result even with premium version. Will try if right result comes in. If you can help with right formula that will be great

    This is an excel sheet formula

    X = fieldname1 (value =200)

    Y = fieldname2 (Value =300)

    z = fieldname3 (value =4)

    b11 =1.29%
    b12 = b11x b13 = 1

    b14= 10000

    b15 = z-b13

    b16 = (y/z-b13)-(y/z)

    b17 = (y/z-b13)-(y/z)95
    b18= ((y/z-b13)-(y/z)95)(b11x)25
    b19 = (((y/z-b13)-(y/z)95)(b11x)25)12

    b20= ((((y/z-b13)-(y/z)95)(b11x)25)12)*3

    B20 is the end result for now. which should be 5,501,931.

    Plugin Author codepeople

    (@codepeople)

    Hello @anilvermapes

    Who is b13 in your code?

    Best regards.

    Thread Starter anilverma.pes

    (@anilvermapes)

    my bad.

    b12= b11*X

    b13= 1

    When I submit response , multiply (*) is getting removed.

    Plugin Author codepeople

    (@codepeople)

    Hello @anilvermapes

    I’m sorry, but there is something wrong with the mathematical operators in your pseudo code. If I replace the variables with the numbers and evaluate the mathematical operations manually, the equation result is -16372422.000000004

    Best regards.

    Thread Starter anilverma.pes

    (@anilvermapes)

    sorry for the trouble. I will get back with right formula with an image.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Large formula and calculated result on button submit in same page’ is closed to new replies.