Calculation of sum

[DrJumaKhudonazarov]

score	2	2
score	3	3
score	2	2
score	10	10
score	11	11

coalesce(${q1},0)+coalesce(${q2},0)+coalesce(${q3},0)+coalesce(${q4},0)+coalesce(${q5},0)

I need a formula that automatically calculates the sum on the above table and tells me the service needed or No can someone help. I have tried to use above  calculation but didn't work

[LaurenceTait]

Are you trying to do this in a report, or within a survey, or somewhere else? Where did this table come from?

[DrJumaKhudonazarov]

with connect  ,  report  survey 123 advanced form 

[LaurenceTait]

If you are asking for our assistance, it would be polite if you provide comprehensive, repsonsive answers, rather than unpunctuated and abbreviate, irrelevant single lines responses. 

We can't help you if you refuse to provide necessary information, and you may find that some people won't help you even if they can.

So I will try once again:

Are you trying to do this in a report, or within a survey, or somewhere else? Where did this table come from?

[Chris_976]

Hello. Based on what I understand of your question, I created a choice list named 'score' and used it in 4 select_one questions as shown below.

 The formula then works just fine :

Hope it can helps !

Cheers

[DrJumaKhudonazarov]

Dear Christophe AGNES,

Thanks indeed helpful. I just don't want to  sum  but also create relationship if  score less than 10  service required if more than 10  No  service  needed 

[Chris_976 · Accepted solution]

Okay, then you just need to add a select_one question with choices set as 'service_required', 'no_service_needed', set "read only" attribute to 'yes' and use the "calculation" attribute if(${sum}<10, 'service_required', 'no_service_needed').

That will calculate automatically the status based on the sum above.

[DrJumaKhudonazarov]

that is great  thank you very much  sorted out now