Require a similar Form Calculation in my form

  • Profile Image
    RogerYelvington01
    Asked on August 05, 2019 at 09:37 AM

    Hi Guys!


    I would like to create a form that can use the calculation below based on this table:

    15650120457E670044-7478-4F2E-A005-61ED2A


    This would be the formula:

    ((Budget * Related %)/ Cost Per Lead)* (Time Frame) = total leads generated


    Example:

    Selected Time Frame: 6 months 

    Monthly Budget Set: $1,550

    Cost Per Lead: $9


    Calculation:

    (($1,550 * 40%) / $9)*(6)= 413 total leads generated


    please advise, thank you!

    Roger

    Screenshot
  • Profile Image
    gerardw
    Answered on August 05, 2019 at 11:03 AM

    Based on your requirement, you can add an Input table and related fields as shown below.

    15650168190508_11.png

    Unfortunately, we cannot show the value inside the Input table, but you can assign value to each cell.

    15650168770508_12.png

    Then calculate values as shown below.

    Here's a screencast on how I did the calculation:

    1565017338screencast0408_2.gif 

    Here is my demo form: https://form.jotform.com/92164500739962

    You can clone it if required - https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    Hope this helps.

     

  • Profile Image
    RogerYelvington01
    Answered on August 05, 2019 at 11:55 AM

    The only thing is, I need to have it where the client doesn't have to select anything in the table matrix.


    IE:

    Is it possible to have a condition, that if they select a term, and then enter an amount - that the form can make the selection for them in the background - in order to complete the calculation?

  • Profile Image
    RogerYelvington01
    Answered on August 05, 2019 at 12:44 PM

    Also, thank you very much for your help!


    This is the form I've started:
    https://form.jotform.com/92164736272965

  • Profile Image
    BDAVID
    Answered on August 05, 2019 at 02:21 PM

    You would need to perform the calculations based on conditions, assuming that the cost per lead is a fixed price($9), I have created these conditions on this demo form: https://form.jotform.com/92165055659969

    ((budget * percentage)/9)*months

    First set:

    1565028896header.png15650288011.png

    1565028602conditions.png

    Second set:

    1565028896header.png15650288322.png

    1565028679conditions_001.png

    Third set:

    1565028896header.png15650287823.png

    1565028721conditions_002.png

    Result:

    1565029243result.gif

    You may clone my form to check it further: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Let us know if you need more help.