I have a constant sum matrix with three column.
I want to set a validation so that the sum of the 1st column may or may not be 100.
But the column 2 and 3 must be equal to 100.
I have a constant sum matrix with three column.
I want to set a validation so that the sum of the 1st column may or may not be 100.
But the column 2 and 3 must be equal to 100.
Best answer by TomG
I have a constant sum matrix with three column.
I want to set a validation so that the sum of the 1st column may or may not be 100.
But the column 2 and 3 must be equal to 100.
You can do this with two custom validation conditions, math expressions and piped values. Statement 1-Scale Point 2 should be equal to 100 minus all the other statements for scale point 2 AND Statement 1/Scale Point 3 should be equal to 100 minus all the other statements for scale point 3.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.