Hey all,
I am stuck at the point where I need to calculate the score in the attached
Excel ODK sheet. I have 10 questions in the sheet hence the score is out of
10 marks (each question is 1 point).
I have tried the calculate function but I think the formula is wrong.
Kindly help me in getting the right formula.
In the choices tab I have highlighted the right answers in yellow meaning
if the respondent chooses that answer, then he/she gets a point (1 mark).
How do I write the formula in a way that will pick the right answer as 1
point and calculate out of 10 so that one can get 4,5,6, or whatever point
they get depending on how they answer the questions.
Thanks in advance.
ODK_HAG3.xls (61.5 KB)
Hi,
if i understood correctly this example can do what you need, doesn't it?
Every option has a number value and at the end you sum the responses values.
check it on https://enketo.org/formtester
Let me know!
Angelo
example.xml (1.7 KB)
example.xls (34.5 KB)
···
Il giorno Sat Jan 24 2015 at 08:07:25 Karisa Kazungu ha scritto:
Hey all,
I am stuck at the point where I need to calculate the score in the
attached Excel ODK sheet. I have 10 questions in the sheet hence the score
is out of 10 marks (each question is 1 point).
I have tried the calculate function but I think the formula is wrong.
Kindly help me in getting the right formula.
In the choices tab I have highlighted the right answers in yellow meaning
if the respondent chooses that answer, then he/she gets a point (1 mark).
How do I write the formula in a way that will pick the right answer as 1
point and calculate out of 10 so that one can get 4,5,6, or whatever point
they get depending on how they answer the questions.
Thanks in advance.
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Thanks Angelo,
I can see your form but I need you to correct the form I have attached.
That way I will understand better. And I tried using the Enketo tester but
it keeps loading and no reply. Kindly assist.
This is the message I get when I submit the form
on http://opendatakit.org/xiframe/
Error: ODK Validate Errors: org.javarosa.xform.parse.XFormParseException:
Invalid calculate for the bind attached to "${Score}" : Couldn't understand
the expression starting at this point: ...'1', $Dancing?}, 0)+ /ODK_HA...
in expression count ${Favourite_movie} , if( ${Favourite_movie} '9',
${Favourite_movie} , 0) + ${Favourite_colour} , if( ${Favourite_colour}
'7', ${Favourite_colour} , 0) + ${Dancing} , if( ${Dancing} '1', $Dancing},
0)+ ${Born} , if( ${Born} '7', ${Born} , 0)+ ${Family_number} , if(
${Family_number} '5', ${Family_number} , 0)+ ${Favourite_car} , if(
${Favourite_car} '2', ${Favourite_car} , 0)+ ${Dream_house} , if(
${Dream_house} '2', ${Dream_house} , 0)+ ${Meeting_month} , if(
${Meeting_month} '5', ${Meeting_month} , 0)+ ${Tribe} , if( ${Tribe} '5',
${Tribe} , 0)+ ${Games_sports} , if( ${Games_sports} '3', ${Games_sports} ,
0) >> XForm is invalid. See above for the errors. Result: Invalid
Thanks in advance.
ODK_HAG3.xls (61 KB)
···
On Saturday, January 24, 2015 at 10:30:04 AM UTC+3, Angelo Lazzari wrote:
>
> Hi,
> if i understood correctly this example can do what you need, doesn't it?
>
> Every option has a number value and at the end you sum the responses
> values.
>
> check it on https://enketo.org/formtester
>
> Let me know!
>
> Angelo
>
>
>
> Il giorno Sat Jan 24 2015 at 08:07:25 Karisa Kazungu <kkar...@gmail.com > ha scritto:
>
>> Hey all,
>>
>> I am stuck at the point where I need to calculate the score in the
>> attached Excel ODK sheet. I have 10 questions in the sheet hence the score
>> is out of 10 marks (each question is 1 point).
>>
>> I have tried the calculate function but I think the formula is wrong.
>> Kindly help me in getting the right formula.
>> In the choices tab I have highlighted the right answers in yellow meaning
>> if the respondent chooses that answer, then he/she gets a point (1 mark).
>> How do I write the formula in a way that will pick the right answer as 1
>> point and calculate out of 10 so that one can get 4,5,6, or whatever point
>> they get depending on how they answer the questions.
>>
>> Thanks in advance.
>>
>> --
>> --
>> Post: opend...@googlegroups.com
>> Unsubscribe: opendatakit...@googlegroups.com
>> Options: http://groups.google.com/group/opendatakit?hl=en
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "ODK Community" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to opendatakit...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
Hi Karisa,
i checked your calculate formula, but... i really don't understand what
you're trying to achieve with it...
It think, before create a complex formula, that we can firstly check the
login on just one variable... for example:
count ${Favourite_movie},
if(${Favourite_movie} '9',
${Favourite_movie}, 0)
What are you trying to represent? Do you have a question with select_one
and you have to check witch is the answer value?
Anyway in the formula there are a lot of sintax errors...the correct sintax
would be: count(nodeset).... and if(condition,do if true, do if false) for
the if... ... you can check everything here
https://opendatakit.org/help/form-design/binding/...
I suggest you to create a simple form with just 2 response and try to
experiment there ...
Bye, let me know
Angelo
···
Il giorno Sat Jan 24 2015 at 10:03:01 Karisa Kazungu ha scritto:
Thanks Angelo,
I can see your form but I need you to correct the form I have attached.
That way I will understand better. And I tried using the Enketo tester but
it keeps loading and no reply. Kindly assist.
This is the message I get when I submit the form on
http://opendatakit.org/xiframe/
Error: ODK Validate Errors: org.javarosa.xform.parse.XFormParseException:
Invalid calculate for the bind attached to "${Score}" : Couldn't understand
the expression starting at this point: ...'1', $Dancing?}, 0)+ /ODK_HA...
in expression count ${Favourite_movie} , if( ${Favourite_movie} '9',
${Favourite_movie} , 0) + ${Favourite_colour} , if( ${Favourite_colour}
'7', ${Favourite_colour} , 0) + ${Dancing} , if( ${Dancing} '1', $Dancing},
0)+ ${Born} , if( ${Born} '7', ${Born} , 0)+ ${Family_number} , if(
${Family_number} '5', ${Family_number} , 0)+ ${Favourite_car} , if(
${Favourite_car} '2', ${Favourite_car} , 0)+ ${Dream_house} , if(
${Dream_house} '2', ${Dream_house} , 0)+ ${Meeting_month} , if(
${Meeting_month} '5', ${Meeting_month} , 0)+ ${Tribe} , if( ${Tribe} '5',
${Tribe} , 0)+ ${Games_sports} , if( ${Games_sports} '3', ${Games_sports} ,
0) >> XForm is invalid. See above for the errors. Result: Invalid
Thanks in advance.
On Saturday, January 24, 2015 at 10:30:04 AM UTC+3, Angelo Lazzari wrote:
Hi,
if i understood correctly this example can do what you need, doesn't it?
Every option has a number value and at the end you sum the responses
values.
check it on https://enketo.org/formtester
Let me know!
Angelo
Il giorno Sat Jan 24 2015 at 08:07:25 Karisa Kazungu kkar...@gmail.com ha scritto:
Hey all,
I am stuck at the point where I need to calculate the score in the
attached Excel ODK sheet. I have 10 questions in the sheet hence the score
is out of 10 marks (each question is 1 point).
I have tried the calculate function but I think the formula is wrong.
Kindly help me in getting the right formula.
In the choices tab I have highlighted the right answers in yellow
meaning if the respondent chooses that answer, then he/she gets a point (1
mark). How do I write the formula in a way that will pick the right answer
as 1 point and calculate out of 10 so that one can get 4,5,6, or whatever
point they get depending on how they answer the questions.
Thanks in advance.
--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Hi Angelo,
Okay this is what I want the calculate formulla to do.
count ${Favourite_movie},
if(${Favourite_movie} '9',
${Favourite_movie}, 0) this means if am right that it should give a
point as 1 when the person chooses option 9 as the answer . if they choose
the other options then that should be translated as a zero point rather no
point at all.
If I had a form with questions with select_one then it would be easier to
do the calculate formula. but my questions are different. they have
select_one but with different answers. I wanted to ask all those questions
but at the same time to put a score out of 10 so that they can answer the
10 questions, each with a different answer.
Again am not that of a guru on ODK so even this - count(nodeset).... and
if(condition,do if true, do if false) will take time to understand not
unless I see it used in the excel sheet. even the other syntaxes i need to
practice. I dont know if I have elaborated well or I have compounded the
issue.
Thanks.
What are you trying to represent? Do you have a question with select_one
and you have to check witch is the answer value?
Anyway in the formula there are a lot of sintax errors...the correct sintax
would be: count(nodeset).... and if(condition,do if true, do if false) for
the if... ... you can check everything here
https://opendatakit.org/help/form-design/binding/.
https://opendatakit.org/help/form-design/binding/..
I suggest you to create a simple form with just 2 response and try to
experiment there ...
···
On Saturday, January 24, 2015 at 3:49:32 PM UTC+3, Angelo Lazzari wrote:
>
> Hi Karisa,
> i checked your calculate formula, but... i really don't understand what
> you're trying to achieve with it...
> It think, before create a complex formula, that we can firstly check the
> login on just one variable... for example:
>
> count ${Favourite_movie},
> if(${Favourite_movie} '9',
> ${Favourite_movie}, 0)
>
> What are you trying to represent? Do you have a question with select_one
> and you have to check witch is the answer value?
>
> Anyway in the formula there are a lot of sintax errors...the correct
> sintax would be: count(nodeset).... and if(condition,do if true, do if
> false) for the if... ... you can check everything here
> https://opendatakit.org/help/form-design/binding/...
>
> I suggest you to create a simple form with just 2 response and try to
> experiment there ...
>
> Bye, let me know
> Angelo
>
>
>
>
>
>
>
>
>
>
> Il giorno Sat Jan 24 2015 at 10:03:01 Karisa Kazungu <kkar...@gmail.com > ha scritto:
>
>> Thanks Angelo,
>>
>> I can see your form but I need you to correct the form I have attached.
>> That way I will understand better. And I tried using the Enketo tester but
>> it keeps loading and no reply. Kindly assist.
>>
>> This is the message I get when I submit the form on
>> http://opendatakit.org/xiframe/
>>
>> Error: ODK Validate Errors: org.javarosa.xform.parse.XFormParseException:
>> Invalid calculate for the bind attached to "${Score}" : Couldn't understand
>> the expression starting at this point: ...'1', $Dancing?}, 0)+ /ODK_HA...
>> in expression count ${Favourite_movie} , if( ${Favourite_movie} '9',
>> ${Favourite_movie} , 0) + ${Favourite_colour} , if( ${Favourite_colour}
>> '7', ${Favourite_colour} , 0) + ${Dancing} , if( ${Dancing} '1', $Dancing},
>> 0)+ ${Born} , if( ${Born} '7', ${Born} , 0)+ ${Family_number} , if(
>> ${Family_number} '5', ${Family_number} , 0)+ ${Favourite_car} , if(
>> ${Favourite_car} '2', ${Favourite_car} , 0)+ ${Dream_house} , if(
>> ${Dream_house} '2', ${Dream_house} , 0)+ ${Meeting_month} , if(
>> ${Meeting_month} '5', ${Meeting_month} , 0)+ ${Tribe} , if( ${Tribe} '5',
>> ${Tribe} , 0)+ ${Games_sports} , if( ${Games_sports} '3', ${Games_sports} ,
>> 0) >> XForm is invalid. See above for the errors. Result: Invalid
>>
>> Thanks in advance.
>>
>>
>> On Saturday, January 24, 2015 at 10:30:04 AM UTC+3, Angelo Lazzari wrote:
>>
>>> Hi,
>>> if i understood correctly this example can do what you need, doesn't it?
>>>
>>> Every option has a number value and at the end you sum the responses
>>> values.
>>>
>>> check it on https://enketo.org/formtester
>>>
>>> Let me know!
>>>
>>> Angelo
>>>
>>>
>>>
>>> Il giorno Sat Jan 24 2015 at 08:07:25 Karisa Kazungu ha scritto:
>>>
>>>> Hey all,
>>>>
>>>> I am stuck at the point where I need to calculate the score in the
>>>> attached Excel ODK sheet. I have 10 questions in the sheet hence the score
>>>> is out of 10 marks (each question is 1 point).
>>>>
>>>> I have tried the calculate function but I think the formula is wrong.
>>>> Kindly help me in getting the right formula.
>>>> In the choices tab I have highlighted the right answers in yellow
>>>> meaning if the respondent chooses that answer, then he/she gets a point (1
>>>> mark). How do I write the formula in a way that will pick the right answer
>>>> as 1 point and calculate out of 10 so that one can get 4,5,6, or whatever
>>>> point they get depending on how they answer the questions.
>>>>
>>>> Thanks in advance.
>>>>
>>>> --
>>>> --
>>>>
>>> Post: opend...@googlegroups.com
>>>> Unsubscribe: opendatakit...@googlegroups.com
>>>
>>>
>>>> Options: http://groups.google.com/group/opendatakit?hl=en
>>>>
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "ODK Community" group.
>>>>
>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to opendatakit...@googlegroups.com.
>>>
>>>
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
>> --
>> Post: opend...@googlegroups.com
>> Unsubscribe: opendatakit...@googlegroups.com
>> Options: http://groups.google.com/group/opendatakit?hl=en
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "ODK Community" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to opendatakit...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
ok, i think you are missing something.
If you create a select_one response named for example "response_1" and you
put this question with this answers:
Which is your favorite movie?
Blade Runner (choice name column = 1)
Top Gun (choice name column = 2)
Alice in wonderland (choice name column = 3)
if the user will select Top Gun the variable response_1 will contain 2, and
if he/she choose Blade Runner, the response variable response_1 will
contain 1...
the next question is:
Which is your favorite food? ( response_2 is the variable name)
Pasta (choice name column = 1)
Pizza (choice name column = 2)
Fish and Chips (choice name column = 3)
If you user check the third option the response_2 will have the 3 value...
So in another calculate field you can consider easily each value and apply
you logic, i mean for example:
if(${response_1} = 1,'Yeah!! You like Blade Runner like me', if(${response_1}
= 2,'ups, i don't like Top Gun','Alice in wonderland is my sun favorite'))
you can put the response_2 variable in that field too...for example:
if ( ${response_1} = 1 and ${response_2} != 3,'things...','other
things')....
is it a bit clear now?
Bye
Angelo
···
Il giorno Sat Jan 24 2015 at 19:08:45 Karisa Kazungu ha scritto:
Hi Angelo,
Okay this is what I want the calculate formulla to do.
count ${Favourite_movie},
if(${Favourite_movie} '9',
${Favourite_movie}, 0) this means if am right that it should give a
point as 1 when the person chooses option 9 as the answer . if they choose
the other options then that should be translated as a zero point rather no
point at all.
If I had a form with questions with select_one then it would be easier to
do the calculate formula. but my questions are different. they have
select_one but with different answers. I wanted to ask all those questions
but at the same time to put a score out of 10 so that they can answer the
10 questions, each with a different answer.
Again am not that of a guru on ODK so even this - count(nodeset).... and
if(condition,do if true, do if false) will take time to understand not
unless I see it used in the excel sheet. even the other syntaxes i need to
practice. I dont know if I have elaborated well or I have compounded the
issue.
Thanks.
What are you trying to represent? Do you have a question with select_one
and you have to check witch is the answer value?
Anyway in the formula there are a lot of sintax errors...the correct
sintax would be: count(nodeset).... and if(condition,do if true, do if
false) for the if... ... you can check everything here
https://opendatakit.org/help/form-design/binding/.
https://opendatakit.org/help/form-design/binding/..
I suggest you to create a simple form with just 2 response and try to
experiment there ...
On Saturday, January 24, 2015 at 3:49:32 PM UTC+3, Angelo Lazzari wrote:
Hi Karisa,
i checked your calculate formula, but... i really don't understand what
you're trying to achieve with it...
It think, before create a complex formula, that we can firstly check the
login on just one variable... for example:
count ${Favourite_movie},
if(${Favourite_movie} '9',
${Favourite_movie}, 0)
What are you trying to represent? Do you have a question with select_one
and you have to check witch is the answer value?
Anyway in the formula there are a lot of sintax errors...the correct
sintax would be: count(nodeset).... and if(condition,do if true, do if
false) for the if... ... you can check everything here
https://opendatakit.org/help/form-design/binding/...
I suggest you to create a simple form with just 2 response and try to
experiment there ...
Bye, let me know
Angelo
Il giorno Sat Jan 24 2015 at 10:03:01 Karisa Kazungu kkar...@gmail.com ha scritto:
Thanks Angelo,
I can see your form but I need you to correct the form I have attached.
That way I will understand better. And I tried using the Enketo tester but
it keeps loading and no reply. Kindly assist.
This is the message I get when I submit the form on
http://opendatakit.org/xiframe/
Error: ODK Validate Errors: org.javarosa.xform.parse.XFormParseException:
Invalid calculate for the bind attached to "${Score}" : Couldn't understand
the expression starting at this point: ...'1', $Dancing?}, 0)+ /ODK_HA...
in expression count ${Favourite_movie} , if( ${Favourite_movie} '9',
${Favourite_movie} , 0) + ${Favourite_colour} , if( ${Favourite_colour}
'7', ${Favourite_colour} , 0) + ${Dancing} , if( ${Dancing} '1', $Dancing},
0)+ ${Born} , if( ${Born} '7', ${Born} , 0)+ ${Family_number} , if(
${Family_number} '5', ${Family_number} , 0)+ ${Favourite_car} , if(
${Favourite_car} '2', ${Favourite_car} , 0)+ ${Dream_house} , if(
${Dream_house} '2', ${Dream_house} , 0)+ ${Meeting_month} , if(
${Meeting_month} '5', ${Meeting_month} , 0)+ ${Tribe} , if( ${Tribe} '5',
${Tribe} , 0)+ ${Games_sports} , if( ${Games_sports} '3', ${Games_sports} ,
0) >> XForm is invalid. See above for the errors. Result: Invalid
Thanks in advance.
On Saturday, January 24, 2015 at 10:30:04 AM UTC+3, Angelo Lazzari wrote:
Hi,
if i understood correctly this example can do what you need, doesn't it?
Every option has a number value and at the end you sum the responses
values.
check it on https://enketo.org/formtester
Let me know!
Angelo
Il giorno Sat Jan 24 2015 at 08:07:25 Karisa Kazungu kkar...@gmail.com ha scritto:
Hey all,
I am stuck at the point where I need to calculate the score in the
attached Excel ODK sheet. I have 10 questions in the sheet hence the score
is out of 10 marks (each question is 1 point).
I have tried the calculate function but I think the formula is wrong.
Kindly help me in getting the right formula.
In the choices tab I have highlighted the right answers in yellow
meaning if the respondent chooses that answer, then he/she gets a point (1
mark). How do I write the formula in a way that will pick the right answer
as 1 point and calculate out of 10 so that one can get 4,5,6, or whatever
point they get depending on how they answer the questions.
Thanks in advance.
--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Angelo,
If it is not a bother, could you please put the formula in the last
attached sheet so that I can easily follow.
I mean using the examples in my questionnaire. That is the formula on row
53 so that it can bring up the score on line 54. I would really appreciate
your help. Thanks a lot.
ODK_HAG3.xls (61 KB)
···
On Saturday, January 24, 2015 at 11:58:31 PM UTC+3, Angelo Lazzari wrote:
>
> ok, i think you are missing something.
>
> If you create a select_one response named for example "response_1" and you
> put this question with this answers:
>
> Which is your favorite movie?
>
> Blade Runner (choice name column = 1)
> Top Gun (choice name column = 2)
> Alice in wonderland (choice name column = 3)
>
> if the user will select Top Gun the variable response_1 will contain 2,
> and if he/she choose Blade Runner, the response variable response_1 will
> contain 1...
>
> the next question is:
>
> Which is your favorite food? ( response_2 is the variable name)
>
> Pasta (choice name column = 1)
> Pizza (choice name column = 2)
> Fish and Chips (choice name column = 3)
>
> If you user check the third option the response_2 will have the 3
> value...
>
> So in another calculate field you can consider easily each value and apply
> you logic, i mean for example:
>
> if(${response_1} = 1,'Yeah!! You like Blade Runner like me', if(${response_1}
> = 2,'ups, i don't like Top Gun','Alice in wonderland is my sun favorite'))
>
> you can put the response_2 variable in that field too...for example:
>
> if ( ${response_1} = 1 and ${response_2} != 3,'things...','other
> things')....
>
> is it a bit clear now?
>
> Bye
> Angelo
>
>
> Il giorno Sat Jan 24 2015 at 19:08:45 Karisa Kazungu <kkar...@gmail.com > ha scritto:
>
>> Hi Angelo,
>>
>> Okay this is what I want the calculate formulla to do.
>>
>> count ${Favourite_movie},
>> if(${Favourite_movie} '9',
>> ${Favourite_movie}, 0) this means if am right that it should give a
>> point as 1 when the person chooses option 9 as the answer . if they choose
>> the other options then that should be translated as a zero point rather no
>> point at all.
>>
>> If I had a form with questions with select_one then it would be easier to
>> do the calculate formula. but my questions are different. they have
>> select_one but with different answers. I wanted to ask all those questions
>> but at the same time to put a score out of 10 so that they can answer the
>> 10 questions, each with a different answer.
>>
>> Again am not that of a guru on ODK so even this - count(nodeset)....
>> and if(condition,do if true, do if false) will take time to understand
>> not unless I see it used in the excel sheet. even the other syntaxes i need
>> to practice. I dont know if I have elaborated well or I have compounded the
>> issue.
>>
>> Thanks.
>>
>> What are you trying to represent? Do you have a question with select_one
>> and you have to check witch is the answer value?
>>
>> Anyway in the formula there are a lot of sintax errors...the correct
>> sintax would be: count(nodeset).... and if(condition,do if true, do if
>> false) for the if... ... you can check everything here
>> https://opendatakit.org/help/form-design/binding/.
>> ..
>>
>> I suggest you to create a simple form with just 2 response and try to
>> experiment there ...
>>
>>
>>
>> On Saturday, January 24, 2015 at 3:49:32 PM UTC+3, Angelo Lazzari wrote:
>>
>>> Hi Karisa,
>>> i checked your calculate formula, but... i really don't understand what
>>> you're trying to achieve with it...
>>> It think, before create a complex formula, that we can firstly check the
>>> login on just one variable... for example:
>>>
>>> count ${Favourite_movie},
>>> if(${Favourite_movie} '9',
>>> ${Favourite_movie}, 0)
>>>
>>> What are you trying to represent? Do you have a question with select_one
>>> and you have to check witch is the answer value?
>>>
>>> Anyway in the formula there are a lot of sintax errors...the correct
>>> sintax would be: count(nodeset).... and if(condition,do if true, do if
>>> false) for the if... ... you can check everything here
>>> https://opendatakit.org/help/form-design/binding/...
>>>
>>> I suggest you to create a simple form with just 2 response and try to
>>> experiment there ...
>>>
>>> Bye, let me know
>>> Angelo
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Il giorno Sat Jan 24 2015 at 10:03:01 Karisa Kazungu ha scritto:
>>>
>>
>>> Thanks Angelo,
>>>>
>>>> I can see your form but I need you to correct the form I have attached.
>>>> That way I will understand better. And I tried using the Enketo tester but
>>>> it keeps loading and no reply. Kindly assist.
>>>>
>>>> This is the message I get when I submit the form on
>>>> http://opendatakit.org/xiframe/
>>>>
>>>> Error: ODK Validate Errors: org.javarosa.xform.parse.XFormParseException:
>>>> Invalid calculate for the bind attached to "${Score}" : Couldn't understand
>>>> the expression starting at this point: ...'1', $Dancing?}, 0)+ /ODK_HA...
>>>> in expression count ${Favourite_movie} , if( ${Favourite_movie} '9',
>>>> ${Favourite_movie} , 0) + ${Favourite_colour} , if( ${Favourite_colour}
>>>> '7', ${Favourite_colour} , 0) + ${Dancing} , if( ${Dancing} '1', $Dancing},
>>>> 0)+ ${Born} , if( ${Born} '7', ${Born} , 0)+ ${Family_number} , if(
>>>> ${Family_number} '5', ${Family_number} , 0)+ ${Favourite_car} , if(
>>>> ${Favourite_car} '2', ${Favourite_car} , 0)+ ${Dream_house} , if(
>>>> ${Dream_house} '2', ${Dream_house} , 0)+ ${Meeting_month} , if(
>>>> ${Meeting_month} '5', ${Meeting_month} , 0)+ ${Tribe} , if( ${Tribe} '5',
>>>> ${Tribe} , 0)+ ${Games_sports} , if( ${Games_sports} '3', ${Games_sports} ,
>>>> 0) >> XForm is invalid. See above for the errors. Result: Invalid
>>>>
>>>> Thanks in advance.
>>>>
>>>>
>>>> On Saturday, January 24, 2015 at 10:30:04 AM UTC+3, Angelo Lazzari wrote:
>>>>
>>>>> Hi,
>>>>> if i understood correctly this example can do what you need, doesn't
>>>>> it?
>>>>>
>>>>> Every option has a number value and at the end you sum the responses
>>>>> values.
>>>>>
>>>>> check it on https://enketo.org/formtester
>>>>>
>>>>> Let me know!
>>>>>
>>>>> Angelo
>>>>>
>>>>>
>>>>>
>>>>> Il giorno Sat Jan 24 2015 at 08:07:25 Karisa Kazungu < kkar...@gmail.com> ha scritto:
>>>>>
>>>>>> Hey all,
>>>>>>
>>>>>> I am stuck at the point where I need to calculate the score in the
>>>>>> attached Excel ODK sheet. I have 10 questions in the sheet hence the score
>>>>>> is out of 10 marks (each question is 1 point).
>>>>>>
>>>>>> I have tried the calculate function but I think the formula is wrong.
>>>>>> Kindly help me in getting the right formula.
>>>>>> In the choices tab I have highlighted the right answers in yellow
>>>>>> meaning if the respondent chooses that answer, then he/she gets a point (1
>>>>>> mark). How do I write the formula in a way that will pick the right answer
>>>>>> as 1 point and calculate out of 10 so that one can get 4,5,6, or whatever
>>>>>> point they get depending on how they answer the questions.
>>>>>>
>>>>>> Thanks in advance.
>>>>>>
>>>>>> --
>>>>>> --
>>>>>>
>>>>> Post: opend...@googlegroups.com
>>>>>> Unsubscribe: opendatakit...@googlegroups.com
>>>>>
>>>>>
>>>>>> Options: http://groups.google.com/group/opendatakit?hl=en
>>>>>>
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "ODK Community" group.
>>>>>>
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>>> an email to opendatakit...@googlegroups.com.
>>>>>
>>>>>
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>> --
>>>> --
>>>> Post: opend...@googlegroups.com
>>>> Unsubscribe: opendatakit...@googlegroups.com
>>>> Options: http://groups.google.com/group/opendatakit?hl=en
>>>>
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "ODK Community" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to opendatakit...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
>> --
>> Post: opend...@googlegroups.com
>> Unsubscribe: opendatakit...@googlegroups.com
>> Options: http://groups.google.com/group/opendatakit?hl=en
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "ODK Community" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to opendatakit...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>