How to ensure all constant sum boxes across rows and columns to total 100 | Experience Community
Skip to main content
Question

How to ensure all constant sum boxes across rows and columns to total 100

  • May 12, 2020
  • 1 reply
  • 158 views
L
Forum|alt.badge.img

Hi!
I have a matrix table that features to columns and three rows. Each constant sum box gives the respondent the opportunity to input a %. Is there a way to enforce all constant sum boxes across both columns and rows to "Must Total" 100? I see options for columns only or rows only total 100, but I want every constant sum box to add up to 100.
This may be an easy question, so apologies for this. What is the best way to do this?
Thanks,
Luke

1 reply

rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • rondev
  • Level 6 ●●●●●●
  • May 12, 2020

You can use custom validation.
For eg you have 3*3 matrix table, then in order to validate first row to 100 apply validation as - select statement 1 - Scale point 1 is equal to $e{ 100 - ( q://QID365/ChoiceNumericEntryValue/1/2 + q://QID365/ChoiceNumericEntryValue/1/3 ) }
q://QID365/ChoiceNumericEntryValue/1/2->select statement 1 -Scale point2 q://QID365/ChoiceNumericEntryValue/1/3-> select statement 1 - Scale point 3

Similarly you need to perform for all rows and all columns.

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