# Require a similar Form Calculation in my form

• 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:

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

Calculation:

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

Roger

• 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.

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

Then calculate values as shown below.

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

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.

• 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?

• 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

• 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:

Second set:

Third set:

Result:

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.