# Sum for multiple selection

Dear, I use odk collect for my survey. Now I want to sum value in multiple
responses question. For example question, what are the thing has been
provided by center?

• Notebook = 0.5 score
• Pen = 0.3 score
• bag = 0.5 score
• uniform = 1.0 score
• other = 1.0 score

If we choose which one, it will count the score and sum with other score we
selected. Example I selected pen and notebook so the total score is o.8.
Could you help me to know how to do this in excel for?

First, do you need this value later in the form, or is it for your data
analysis.

If it is for the analysis of the data, you should probably compute this in
Excel or whatever analysis system you are using.

If you need it later in the form, you will generally be comparing this
value to a threshold.

In that case, you can use weighted-checklist() which returns true if a
value is within a (minrange, maxrange) range.

weighted-checklist(minrange, maxrange, selected(\${mc},'notebook'),
selected(\${mc},'pen'), ..., 0.5, 0.3, ...)

See:

https://opendatakit.org/help/form-design/binding/

Unfortunately, there is no function to return the computed value. If you
absolutely need that, you would need to write something like:

if( selected(\${mc}, 'notebook'), 0.5, 0.0) +
if( selected(\${mc}, 'pen'), 0.3, 0.0) + ...

··· On Wed, May 11, 2016 at 9:57 PM, Srou Lihol wrote:

Dear, I use odk collect for my survey. Now I want to sum value in multiple
responses question. For example question, what are the thing has been
provided by center?

• Notebook = 0.5 score
• Pen = 0.3 score
• bag = 0.5 score
• uniform = 1.0 score
• other = 1.0 score

If we choose which one, it will count the score and sum with other score
we selected. Example I selected pen and notebook so the total score is o.8.
Could you help me to know how to do this in excel for?

## --

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

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Use if function, eg.. if(\${q1},'cabbage'),1,0)+.... in ca calculate field

··· On Thursday, May 12, 2016 at 7:57:10 AM UTC+3, Srou Lihol wrote: > > Dear, I use odk collect for my survey. Now I want to sum value in multiple > responses question. For example question, what are the thing has been > provided by center? > > - Notebook = 0.5 score > - Pen = 0.3 score > - bag = 0.5 score > - uniform = 1.0 score > - other = 1.0 score > > If we choose which one, it will count the score and sum with other score > we selected. Example I selected pen and notebook so the total score is o.8. > Could you help me to know how to do this in excel for? > > Thanks in advance >

Thanks for your supporting. Now I used
if( selected(\${mc}, 'notebook'), 0.5, 0.0) +
if( selected(\${mc}, 'pen'), 0.3, 0.0) + ...
It worked well.

··· On Fri, May 13, 2016 at 10:49 AM, cyrus karoki wrote:

Use if function, eg.. if(\${q1},'cabbage'),1,0)+.... in ca calculate field

On Thursday, May 12, 2016 at 7:57:10 AM UTC+3, Srou Lihol wrote:

Dear, I use odk collect for my survey. Now I want to sum value in
multiple responses question. For example question, what are the thing has
been provided by center?

• Notebook = 0.5 score
• Pen = 0.3 score
• bag = 0.5 score
• uniform = 1.0 score
• other = 1.0 score

If we choose which one, it will count the score and sum with other score
we selected. Example I selected pen and notebook so the total score is o.8.
Could you help me to know how to do this in excel for?