topic Re: Calculation - Discrepancies in ArcGIS Survey123 Questions

Calculation - Discrepancies

Anonymous User — Mon, 26 Mar 2018 02:38:16 GMT

Hi all,

I was under the assumption that surveys would always populate calculated values when viewing surveys through "SENT" or "INBOX" folders. Even when users overwrite the calculation values during submission.

But, I noticed some of my surveys display the overwritten values submitted by users instead (when viewing surveys through "SENT" or "INBOX" folders).

Anyone know the reason for this discrepancy?

Any help is greatly appreciated

Thanks,

Gee

Re: Calculation - Discrepancies

Anonymous User — Mon, 26 Mar 2018 02:56:06 GMT

Hi Gee,

Yes, this is expected and by design. When loading a survey via Sent or Inbox you are loading the existing values in the survey for editing. Calculations on questions in the survey are therefore not re-calculated to avoid over-writing the values that may have been modified previously. To run the calculations again you can select the refresh icon next to each question.

Phil.

Re: Calculation - Discrepancies

Anonymous User — Mon, 26 Mar 2018 03:07:02 GMT

But, I have multiple other surveys where this is NOT the case (I.E. would always populate calculated values when viewing surveys through "SENT" or "INBOX" folders. Even when users overwrite the calculation values during submission.)

Re: Calculation - Discrepancies

Anonymous User — Mon, 26 Mar 2018 04:22:33 GMT

Are you seeing the different behaviour in different surveys on the same question type, or on different question types? Can you provide more details and examples?

We have made some improvements for 2.7 and further work planned for 3.0 regarding calculations and the behaviour when opening surveys from the various different boxes.

Phil.

Re: Calculation - Discrepancies

Anonymous User — Mon, 26 Mar 2018 18:56:05 GMT

Hi Phil,

The issue seems to be survey specific (all calculations within survey are either affected or not). And questions types can vary.

I have emailed you 2 xlsx forms (with the 2 different behaviours).

Hope to see a fix soon

Thanks,

Gee

Re: Calculation - Discrepancies

Anonymous User — Tue, 27 Mar 2018 03:24:16 GMT

Hi Geethaka,

Thanks for your 2 xlsx surveys. The cause of the issue is the repeat in your second survey, which you do not have a repeat in your first survey. The calculations inside the repeat point to calculations outside the repeat, and upon loading the survey from Inbox, Sent or Drafts, these calculations inside repeat are causing the other calculations to re-run also, even though they have manually over-written values. This is a known bug and we are aiming to resolve this in a near future release.

Phil.

Re: Calculation - Discrepancies

Anonymous User — Tue, 27 Mar 2018 04:34:34 GMT

Thanks so much for the explanation.

But, I think this occurs with any survey with a REPEAT type in it (even without any calculations within REPEAT).

I emailed you an example of this instance.

Hope to see a fix soon.

Thanks,

Gee

Re: Calculation - Discrepancies

Anonymous User — Mon, 28 May 2018 22:10:42 GMT

Hi Philip Wilson‌, do you know if this issue will be fixed in the next release?

Thanks,

Gee

Re: Calculation - Discrepancies

Anonymous User — Mon, 28 May 2018 22:54:30 GMT

Hi Gee,

We currently have a few issues in our backlog regarding calculations and defaults which we are aiming to resolve in near future. At this stage I can not confirm if all these changes and fixes will make it into the next release, but as soon as we have clarification will let you know.

Phil.

Re: Calculation - Discrepancies

Anonymous User — Tue, 10 Jul 2018 15:22:37 GMT

Fixed in the latest version

THANKS