laptop and a wrench

Bug

Calculations relying on default values in non-relevant fields behave differently in the latest version of Survey123 for ArcGIS.

Last Published: January 17, 2020 ArcGIS Survey123
Bug ID Number BUG-000127379
SubmittedDecember 13, 2019
Last ModifiedJune 5, 2024
Applies toArcGIS Survey123
Version found3.7
Operating SystemWindows OS
Operating System Version10.0
StatusWill Not Be Addressed

Additional Information

BUG-000097105 is fixed in Survey123 for ArcGIS 3.6. If a question is not relevant, it should not have any value until it becomes relevant. In this example, the default of 0 is used for all questions and all values are summed up although they are not relevant. This works in Survey123 for ArcGIS 3.5 or earlier, since non-relevant values are considered as 0. However, in Survey123 for ArcGIS 3.6, non-relevant questions are stored as null. Null + a value = Null. The correct way to construct the Total Depth calculation in this example is to use: coalesce(${Field_0},0) + coalesce(${Field_1},0) + coalesce(${Field_2},0) + coalesce(${Field_3},0).

Workaround

Refer to the GeoNet: Calculation question comment for a detailed explanation.

Steps to Reproduce

Bug ID: BUG-000127379

Software:

  • ArcGIS Survey123

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options