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
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.
that is great thank you very much sorted out now
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?
with connect , report survey 123 advanced form
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
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
Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
