Survey calculations stopped working.

Question

How do I calculate the totals for select multiple questions? I am sure that is what I have to work around given the ones without it calculate correctly. I am using the latest version of Survey123, so that has been ruled out as an issue. I have tried if then statements, coalesce, string-length, etc. and none of them seem to be working.

Thanks,

Adult ID Full Test.xlsx

dougbrowning · Answer

Yep.  If a field is hidden due to a relevant it is always ''.  You cannot make it 0.

ClaibornPhillips1 · Answer

I added the coalesce to the totals lines, but what can I do to keep a value of zero for each line?

On the Survey123 website, only the data with the coalesce or a number entered has a value.

dougbrowning · Answer

Ok I see it now.  Your sum fields are trying to sum fields that are hidden due to the relevant.  When a field is hidden it gets the value '' - even if it is an integer.  It does not get the default value.  This '' is breaking your + sum.

So if I select just atropos then the other 3 values in this calc are '' and it breaks.

${An_atro_F} + ${An_cru_F} + ${An_pun_F} + ${An_qua_F}

How I do it is have a second field after each number that has and if.

if(${An_atro_F}='',0,${An_atro_F})

That way the calc just uses the 0 and you get an answer.

But There is now a new function called coalesce() also.  You can use it to only use the value if it is not ''.

Shortened example

coalesce(${An_atro_F},0) + coalesce(${An_cru_F},0) ...etc

I was doing the first way mainly because I had to also count for a avg but this coalesce seems easier to write out.

See Formulas—Survey123 for ArcGIS | Documentation

Hope that helps.