topic Re: Updating calculation from various fields in ArcGIS Survey123 Questions

Updating calculation from various fields

KerryKang1 — Tue, 03 Dec 2019 17:58:26 GMT

Hello all,

I have a question for showing calculation result while data is being entered.

There is a label showing 'Total Value' where the values are added from item 1 - 10. My current calculation is

${item1} + ${item2} + ${item3} +${item4} + ${item5} + ${item6}+${item7} + ${item8} + ${item9}+${item10}.

The problem with this method is that the Total value is not updated until all 10 values are added. Users may enter values for all 10 items or maybe only 8 or even 5. How can I make the total value updated as each item value is entered, not waiting until the last item value is entered?

I could use repeat and using sum for item but this will create nested repeat for my survey, and I cannot use as this survey needs to be opened through web browser.

Cheers,

Re: Updating calculation from various fields

IsmaelChivite — Tue, 03 Dec 2019 18:05:05 GMT

Hi. If any of the input values in your formula is null, the output will be null. To work around this you can:

* Set a default value of 0 to all questions (using the default XLSForm column)

* Modify your expression as follows:

coalesce(${item1},0) + coalesce(${item2},0) + coalesce(${item3},0) ...

Re: Updating calculation from various fields

KerryKang1 — Tue, 03 Dec 2019 18:16:02 GMT

Hi Ismael, this method worked perfect. Thanks!

Cheers,