Constant Sum Question: One (of 4) Statements be greater than zero? | XM Community
Skip to main content

Constant Sum Question: One (of 4) Statements be greater than zero?

  • August 2, 2022
  • 4 replies
  • 62 views

Forum|alt.badge.img

Hello! I am trying to ask a constant sum question where respondents must enter a breakdown of their budget. I have four different "statements" in the constant sum question and clients can enter values into each. One of these statements MUST be greater than zero. Is this possible?

4 replies

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • 6083 replies
  • August 2, 2022

Use custom validation with something like this:
stmt1 is greater than 0
OR stmt2 is greater than 0
OR stmt3 is greater than 0
OR stmt4 is greater than 0


Forum|alt.badge.img
  • Author
  • 2 replies
  • August 2, 2022

Thanks, TomG! I already have a validation that the Total Sum must equal the Total Sum from a different question (Must Total ${q://QID21/TotalSum}). Is it possible to do both of these things on the same question?


TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • 6083 replies
  • August 2, 2022

Yes, it is a little tricky. You can do a custom validation rule something like:
If stmt1 equal to $e{ q://QID21/TotalSum - q://QIDx/ChoiceNumericEntryValue/2 - q://QIDx/ChoiceNumericEntryValue/3 - q://QIDx/ChoiceNumericEntryValue/4 }
AND (logic set)
stmt1 is greater than 0
OR stmt2 is greater than 0
OR stmt3 is greater than 0
OR stmt4 is greater than 0
where QIDx is the QID of your constant sum.


Forum|alt.badge.img
  • Author
  • 2 replies
  • August 11, 2022

Just wanted to circle back to let you know this custom validation rule totally worked! Thanks so much for your help, TomG!