nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

タグ付けされた投稿をもっと見る

Accepted answers

Chris_976

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.

All comments

DrJumaKhudonazarov

that is great thank you very much sorted out now

Chris_976

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

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?

DrJumaKhudonazarov

with connect , report survey 123 advanced form

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

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.

Capture d'écran 2025-04-11 092322.png

The formula then works just fine :

Hope it can helps !

Cheers

LaurenceTait

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

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.