Survey123 Calculation referencing a null decimal question

Question

Hello,

I am trying to write a calculation and I can't quite get it to work.

I have attached a couple screen shots to help explain what is going on.

The calculations I have written do not create any errors yet how the survey is filled in or rather not filled in, the answers to other questions appear when they should be null.  There are no defaults populated other than for Water Temp Device.

if(selected(${WTEMP_NUM},'NaN'),'',string('None'))

StrathconaBTS · Answer

Thanks for posting this James. I am successfully using count-selected for an empty check, however I did find a bug. If the name of the selected option is zero it does not return the appropriate count it returns zero. EG assume ${select_one_question}, choice name: 0, label: 'test', calling function count-selected(${select_one_question}) returns 0 instead of the expected 1.

KatherinePadilla · Answer

This works out well.  Thank you!!

IngridAldridge1 · Answer

Hi Katherine,

The selected() calculation only works on the select_one or select_multiple question types.  For a decimal it is better to look at the length of the response.  For example: if(string-length(${WTEMP_NUM})>0,'','None').  This will look at the length of the response for your field ${WTEMP_NUM} and if it is greater than 0 i.e. filled in with anything it will give you a blank response '' but if it is not filled it will return the work None. A variation of this should also work in your relevancy statements as well.