How do I have a survey end if there are four statements (total of 100) in a constant sum question and respondent will be disqualified if the sum of the first and third statements total than 20.
Solved
constant sum question / disqualified if total of two statements less than 20
+1Best answer by vgayraud
Hi,
You could store the sum of 1 and 3 in an ED field in the survey flow with a math operation and branch to a custom EoS element if the condition is validated in branch logic.
+65Hi,
You could store the sum of 1 and 3 in an ED field in the survey flow with a math operation and branch to a custom EoS element if the condition is validated in branch logic.
+1Thank you so much! I appreciate the quick reply!
One question: your formula includes “QID87” how do you determine that it should be 87?
+65That’s just mine, yours is most probably something else.
You can turn QIDs in the survey builder in the tools menu:
+1sorry to bother you again….
I tested your method and unfortunately it is ending the survey even when the total of 1+3 is greater than 20.
I checked the data and the SUM field is always showing 0 regardless of the numbers entered, so I’m guessing that the numbers for 1+3 are not correctly being calculated and/or populated in the SUM field.
What do you think might be the issue?
+65Most probably the spacing in your formula.
$e{ q://QID87/ChoiceNumericEntryValue/1 + q://QID87/ChoiceNumericEntryValue/3 }If not, maybe your choices ids are not 1 and 3 for some reason.
Try piping them from the UI to see which ids you get:
Also, it wasn’t clear form your original message what the condition was. If it’s > 20, don’t use the condition I posted. :)
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.