Survey123 relevancy calculation won't calculate if hidden

354
1
08-30-2019 07:59 AM
MattMulder
New Contributor III

Hello all, 

I recently came across this issue that if a question or group is hidden based on a dependency and you have a calculation that looks at this field, the calculation will not act properly.

   In this scenario I have a tally for work orders for a different set of rooms, if the unit does not have a certain type of room it won't show this group, however a summary table still needs to look at the total work orders for that room if it's chosen. When the room is not chosen in recent time it has left the summary table blank, not calculating anything. 

     My work around for this has been to remove the calculation from the group, without relevancy clause and just keep it compact. Were any updates made to survey123 schema that would have altered this? It seems like a new bug

Thanks

0 Kudos
1 Reply
DougBrowning
MVP Esteemed Contributor

All relevant fields that are not showing should always be "" empty string.  (note there is another bug where a default will be added to a relevant that is not showing). This was not always working before but was fixed in 3.5.  There was a post about this when 3.5 came out but I cannot find it.  There were also some other posts about it today.

Using hidden or calculate is the way to go.