Matrix, constant sum, custom validations | Experience Community
Skip to main content
Question

Matrix, constant sum, custom validations

  • July 30, 2020
  • 1 reply
  • 67 views
Natasha
Level 2 ●●
Forum|alt.badge.img+8

Hi everyone,
I am asking a constant sum question in a survey. One column needs to equal 100% while the other two columns need to equal a particular sum.
I cannot figure out how to provide custom validation for this question. Does anyone have ideas? Also, I need to add force response to this question as well.
Screen Shot 2020-07-30 at 5.39.07 PM.pngThank you!

1 reply

rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • rondev
  • Level 6 ●●●●●●
  • July 30, 2020

We need to use custom validation here.
For example the custom validation for first column sum = 100 will be:
option A_Percentage = $e{ 100 - ( option B_Percentage + option C_Percentage ) }
So in the custom validation pop up, in the last box, you can put the math operation as shown above, which will be similar to below
option A_Percentage equal to $e{ 100 - ( q://QID505/ChoiceNumericEntryValue/2/1 + q://QID505/ChoiceNumericEntryValue/3/1 ) }

Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
Terms & ConditionsAccessibility statement