- Posts: 12
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Grand Total matches previous answer?
- KimBracknell
- Topic Author
- Offline
- New Member
Less
More
5 years 10 months ago #169364
by KimBracknell
Grand Total matches previous answer? was created by KimBracknell
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.
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.
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12881
- Thank you received: 3965
5 years 10 months ago #169367
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Grand Total matches previous answer?
Hi, Kim,
assuming the "previous question" is a numerical question Q1,
enter in "question validation equation" of your array:
sum(self)==Q1
Regards
Joffm
assuming the "previous question" is a numerical question Q1,
enter in "question validation equation" of your array:
sum(self)==Q1
Regards
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- KimBracknell
- Topic Author
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 0
5 years 10 months ago #169368
by KimBracknell
Replied by KimBracknell on topic Grand Total matches previous answer?
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.
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.
The topic has been locked.