We are attempting to make an ROI calculator that will calculate numbers and percentages inputted by the user.
Hi
I am trying to create multiple pages that will calculate user inputs on final page
I am hoping we can have a mix of inputs like percentages and whole numbers / $
cheers
des
Hi
Step 1: Annual Benefit Calculations
In the first step, users select the outcomes they want to calculate. Each outcome’s Annual Benefit (ab) is calculated using a simple formula:
(x * y) * z = Annual Benefit (ab)
Here’s an example for one of the outcomes:
Outcome: Increased Engagement
- Variable 1 (x): Number of Contacts
- Variable 2 (y): Increase in Engagement Rate (%)
- Variable 3 (z): Value per Engaged Contact ($)
Example Inputs:
- Number of Contacts: 10,000
- Increase in Engagement Rate: 15%
- Value per Engaged Contact: $30
Example Calculation:
(10,000 * 0.15) * $30 = $45,000
This formula structure is consistent across all outcomes, with different variables tailored to each. For instance:
- Improved Efficiency: Projects * Time Saved per Project * Cost per Unit Time
- Reduced Costs: Current Spend * Reduction Percentage
- Improved Trust: Cost of Opposition * Reduction Percentage
- Improved Satisfaction: Complaints * Decrease Percentage * Cost per Complaint
If multiple outcomes are selected, the Annual Benefits are summed into a Total Annual Benefit (total_ab).
Step 2: ROI Calculation
In the second step, the ROI is calculated using the formula:
ROI = (Total Annual Benefits - Total Costs) / Total Costs
Example:
- Total Annual Benefits: $357,000
- Total Costs: $37,550
Calculation:
($357,000 - $37,550) / $37,550 = 8.51
This ROI indicates that for every $1 spent, the return is $8.51.
Problem Description
While I’ve set up variables and defined calculations for each step, the results are not calculating correctly. To simplify troubleshooting I’ve created a simplified Typeform focused solely on calculating the Annual Benefits for a single outcome: Increased Engagement. Below are the key aspects of my setup:
- Variables for each input and calculation have been created.
- The formula is applied to each outcome and Total Annual Benefit.
- The ROI calculation references the Total Annual Benefit and Total Costs.
I suspect an issue with how the variables are referenced or calculated across steps. Any insights on debugging this or ensuring the multi-step calculations work smoothly in Typeform would be greatly appreciated.
Note
Default values are provided for all fields in case users don’t have specific numbers, and a disclaimer clarifies this.
using your details, i put together a sample version of the quiz at this link
i used a multiple select multiple choice for the first question and built the logic off the top of that.
i made an assumption in here, that the total costs would be equal to the response to ‘current spend’ + ‘cost of opposition’ - i was uncertain how you gathered your costs but that’s how i did it in the example.
have a walk through the quiz - and let me know that you think: where does your calculation logic fall apart?
des
Let us know how this goes for you,
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.