How to ensure all constant sum boxes across rows and columns to total 100 | XM Community
Question

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

  • 12 May 2020
  • 1 reply
  • 53 views

Badge

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

Userlevel 7
Badge +22

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.

Leave a Reply