Grand Total matches previous answer?

More
3 months 2 weeks ago #169364 by KimBracknell
KimBracknell created the topic: Grand Total matches previous answer?
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.

Please Log in or Create an account to join the conversation.

More
3 months 2 weeks ago #169367 by Joffm
Joffm replied the 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


Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in or Create an account to join the conversation.

More
3 months 2 weeks ago #169368 by KimBracknell
KimBracknell replied the 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.

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!