Hi there,

I have added a question using Array (Texts) with the 'Numbers Only', 'Show Totals for Rows and Columns' and 'Show Grand Total' attributes switched 'On'. The array is 5 rows by 2 cols. I need to ensure that the "Grand total' matches the answer from a previous question. Can I achieve this in LimeSurvey?

TIA,
Kim.

Hi, Kim,

assuming the "previous question" is a numerical question Q1,
enter in "question validation equation" of your array:

sum(self)==Q1

Regards
Joffm

Thx Joffm,

I managed to get the validation to work by totalling the cells in each column i.e.
sum(Q10a_SQ021_SQ031, Q10a_SQ022_SQ031, Q10a_SQ023_SQ031, Q10a_SQ024_SQ031, Q10a_SQ025_SQ031, Q10a_SQ026_SQ031, Q10a_SQ027_SQ031, Q10a_SQ021_SQ032, Q10a_SQ022_SQ032, Q10a_SQ023_SQ032, Q10a_SQ024_SQ032, Q10a_SQ025_SQ032, Q10a_SQ026_SQ032, Q10a_SQ027_SQ032)== Q9

Q9 was the matching total. All good!

Cheers,
Kim.