Incorrect calculation?! | Community
Skip to main content
Answered

Incorrect calculation?!


Hey all, 

 

I have created a form with 20 questions evaluated on a 5-point scale each. I then want to display the outcome SUM of all the scores. Here are the steps I went through:

  1. Attached a scoring to each value from 1 to 5
  2. Then, created a variable: @variable_running_total
  3. In logic, for each question I added @score to the @variable_running_total
  4. Then, at the end screen I created a slide: your score is @variable_running_total / 100

Okay, so, the max is 100, right? The min is 20, right?

Why am I getting 210 when I put 1 for all the questions and 1050 when I put 5 for all the questions?!

Please help! 

Best answer by john.desborough

@Konstantin Tskhay - can you take some screenshots and share them? typicall, using @score and adding it to the variable is going to screw up the number. - score is a total variable. 

what it’s doing is this .. based on yoru 5 point scale: 

q1 =5   @score = 5   variable = 5

q2=5   @score =10 variable =15

q3 = 5 @score =15 variable = 30

q4 = 5 @score = 20 variable = 50

 

etc.. 

does that make sense? 

add q1 to variable 

add q2 to variable 

add q3 to variable….. that will get the right numbers

 

des

View original

5 replies

  • Navigating the Land
  • 1 reply
  • October 26, 2023

 I have a registration for with a complex series of branching and calculations to determine ticket pricing for a conference. I have had a few people reach out with incorrect calculations, and I am trying to track down the logic error.

Is it possible to print out the full list of Branching and Calculations? 

The individual logic steps I have set up appear to be correct. However, there must be some sequencing error leading to the increased pricing. I would love to be able to see the full list of these to help sort that out, but on my screen I can only see a portion at a time. I have tried printing the browser window, but it will only print a portion of the visible section (even if I Zoom out to fit more in the window, it still won’t print what it shows).

Thanks for any tips!


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5279 replies
  • Answer
  • October 26, 2023

@Konstantin Tskhay - can you take some screenshots and share them? typicall, using @score and adding it to the variable is going to screw up the number. - score is a total variable. 

what it’s doing is this .. based on yoru 5 point scale: 

q1 =5   @score = 5   variable = 5

q2=5   @score =10 variable =15

q3 = 5 @score =15 variable = 30

q4 = 5 @score = 20 variable = 50

 

etc.. 

does that make sense? 

add q1 to variable 

add q2 to variable 

add q3 to variable….. that will get the right numbers

 

des


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5279 replies
  • October 26, 2023

@BalliBalli - unfortunately there is no native function to do that. 

one technique i use is to duplicate the form and put in statement pages after each ‘addition’ to the calculation and display all the variables and answers to date and the output of the calculations … that let’s me look at the process through the logic path step wise to try and catch errors. 

pro tip: create a spreadsheet that has the logic rules you want in it BEFORE YOU START and validate that the calcs work on that before you start putting the rules in place.. That way you can use this as a checklist to denote having completed the entry of each rule AND validate the output through the logic. 

just some thoughts

 

des


@john.desborough this solved it -- thank you! 

 

Did not realize score was a also a total variable! 


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5279 replies
  • October 26, 2023
Konstantin Tskhay wrote:

@john.desborough this solved it -- thank you! 

 

Did not realize score was a also a total variable! 

glad that worked!

 

des