topic Re: Calculation not working as expected on Repeat in ArcGIS Survey123 Questions

Calculation not working as expected on Repeat

AlexGodfrey1 — Fri, 14 Sep 2018 04:04:38 GMT

Hi Guys,

Hoping you can shed some light

I have a survey with a repeat, and the calculations don't seem to work automatically unless I have a default populated. In this case '0'

Problem is, that I can't put a default on the repeat? or can i?

Kind Regards,
Alex

Re: Calculation not working as expected on Repeat

JamesTedrick — Fri, 14 Sep 2018 17:20:35 GMT

Hi Alex,

Is this a first-level or second-level (nested) repeat? There is a specific issue we are looking to address on nested repeats, otherwise default values should work within the repeat.

Re: Calculation not working as expected on Repeat

AlexGodfrey1 — Sun, 16 Sep 2018 23:48:13 GMT

Hi James,

Thanks for the reply.

This is on a first-level repeat.

Cheers,
Alex

Re: Calculation not working as expected on Repeat

AlexGodfrey1 — Mon, 17 Sep 2018 02:17:50 GMT

Hi James,

Thought I’d Attach Survey to make it easier ☺

Cheers,

Alex

Re: Calculation not working as expected on Repeat

JamesTedrick — Mon, 17 Sep 2018 16:40:28 GMT

Thanks Alex,

One thing to note is the order of the questions/calculations - there's an implicit top to bottom order of calculation; I see that line 27 depends on line 33 having a value - this might be causing some of the behavior issues.

Re: Calculation not working as expected on Repeat

AlexGodfrey1 — Tue, 18 Sep 2018 00:09:30 GMT

Hi James,

I made the changes as suggested, it was actually an error so well spotted! ☺

Still no dice however, repeat is not calculating.

Kind Regards,

Alex

Re: Calculation not working as expected on Repeat

AlexGodfrey1 — Tue, 18 Sep 2018 01:21:00 GMT

HI James,

We just tested the Survey on v2.7 and the issue is gone, however we get another issue pop up which was solved in a later release.. looks like a bug.

Cheers

Alex

Re: Calculation not working as expected on Repeat

AlexGodfrey1 — Mon, 08 Oct 2018 05:50:45 GMT

Hi James,

Did you have a chance to have another look at this??

Seems to be a bug.

Cheers,

Alex

Re: Calculation not working as expected on Repeat

Anonymous User — Wed, 10 Oct 2018 02:40:16 GMT

Hi Alex,

I had a look at your survey and tested with latest beta build available on EAC, which include some enhancements to repeats and calculations, it appears with latest builds your survey and calculations in repeats are working correctly. In doing so however I noticed that the calculations inside the repeat reference the other questions inside the repeat that are being set to a default of 0. The calculations will not work on load if it is trying to multiple by 0. Once a new value is entered the calculations work so you need to update the calculation to take this into consideration, or it can only be updated once the values are not 0.

On top of that, we do have a known bug for repeat count and default values not populating on 2nd repeat rows or above. The 1st repeat records works as expected, but not the others. I have added your comments and survey example to this issue for further testing.

Can you test your survey with the latest beta builds available on EAC and let me know if you are still having issues with calculations and defaults.

Phil.

Re: Calculation not working as expected on Repeat

JohnathanHasthorpe — Mon, 22 Oct 2018 04:33:19 GMT

We have a fix for the repeat_count issue on the EAC - please test out the latest release candidate builds here: https://earlyadopter.esri.com/project/home.html?cap=%7bE69EF91F-4574-4B98-882C-651F7B518EB7%7d

Re: Calculation not working as expected on Repeat

WayneDodgens1 — Fri, 08 Feb 2019 18:14:48 GMT

Phil,

Was this bug relating to default values in repeats addressed in the latest release (3.2)? I'm having some issues with calculations in a repeat (web form only) that seems to be a bug.

Thanks,

Wayne

Re: Calculation not working as expected on Repeat

Anonymous User — Sun, 10 Feb 2019 22:22:21 GMT

Hi Wayne,

Yes the above repeat bug I mentioned was fixed in 3.2. The updated version is available in the app stores and Survey123 website to download now. We do still have one issue with nested repeats and data not displaying in first record of nested repeat with relevant expression referencing a question outside of the nested repeat when open from Drafts/Sent/Inbox, but this is different to above issues.

As for the web form, not all repeat and nested repeat, and xlsform advanced expressions that work in the app work in the webform. Can you share exactly what is not working and any error messages?

Phil.

Re: Calculation not working as expected on Repeat

WayneDodgens1 — Tue, 12 Feb 2019 02:59:55 GMT

Thanks for the response Phil.

I have a repeat that has a dropdown choice, then a pulldata that gets prices from a CSV. It also has a calculation based on these selections within the repeat. Outside of the repeat these are summed up and presented to the user. It's an estimate of equipment rental costs.

When you add a second item to the repeat in the web form, it will not calculate inside the repeat. (which I assume causes the calculations outside the repeat to fail, because it is dependent).

I've attached the form and pulldata CSV. I'm using the connect version 3.2.196.

Thanks for your willingness to help.

Wayne

Re: Calculation not working as expected on Repeat

Anonymous User — Wed, 13 Feb 2019 05:48:47 GMT

Hi Wayne,

There are two things I found that could be the cause of the issues you are having. Firstly, the csv file has a blank row at the end of it, if you open in NotePad++ or similar advanced text editor, you will see this blank row, however if you open in Excel you will not see it. We have seen that these blank rows can cause issue with web app:

Secondly, the note EstUnitCost has two dollar signs $ in the label, one is for the question it is referencing, the other I guess is for you to show it on the form as a dollar amount, this could cause an issue as web app may not be processing this correctly.

Estimated Rental Cost for Selected: $${calcEstUnitCost}

Regards,

Phil.

Re: Calculation not working as expected on Repeat

WayneDodgens1 — Wed, 13 Feb 2019 22:40:50 GMT

Great catch on the extra line in the CSV, however that wasn't the issue. I removed the extra line and the additional $ symbol and the web form still doesn't work as expected. Oddly, if I add a second repeat the form doesn't calculate, but if I delete the first repeat and the formerly second repeat becomes the only repeat, the form calculates to the new values, as expected.

Should I be applying a default value (or removing it) or perhaps a test for 0 string length anywhere? I'm trying the if(string-lenght()>0,.....,0) trick next. Hoping if there is a 0 value, I can at least get it to show a value in the calculated fields.

It works great in the field app.

Thanks for your help!

Re: Calculation not working as expected on Repeat

Anonymous User — Wed, 13 Feb 2019 23:37:29 GMT

Hi Wayne,

I had a further look and also used the updated survey with those issues fixed I mentioned yesterday, it appears this is a bug with the web app and will need to be fixed in a future release. I have logged an issue for it and updated with your comments and survey. Will keep you posted when we have a fix for it.

In the meantime, you may want to try and change the way you are trying to use the calculation in a label on a note question in the repeat, and move it to a integer/decimal field and actually store the value, and put the calculation in the calculations column. This should work and not affect the total, just means you have more stored values in the repeat, not just in a note.

Phil.

Re: Calculation not working as expected on Repeat

WayneDodgens1 — Thu, 14 Feb 2019 00:20:12 GMT

Thanks again Phil.

Using your suggestion to add the calculations as interger fields, it became clear that the repeated pulldata() function is not pulling the data which cascades down to the other calculations. That may be a place to start looking in your bug hunt. Thanks again, and I'll just remove these repeat calculations for now.

Wayne