AnsweredAssumed Answered

Calculations on an unknown number of fields

Question asked by j.biendaraconterra-de-esridist Employee on Nov 29, 2018
Latest reply on Dec 7, 2018 by j.biendaraconterra-de-esridist

Hello,

 

I have a survey for a number of measurements, in total 32. The measurements compose a matrix of 4 by 8 (4 different heights, 8 different wind directions). Not all points must be measured, it is up to the field guy which measurements he/she takes.

 

All possible measurement points are represented by an integer question in my survey. For various reasons I am not using repeats.

 

Now, I want to make some calculations like max(), min(), sum(), avg(), but only for those measurement points that do have a value.

 

Does anyone have a tip how I can tackle this task (efficiently) in Survey123?

 

Thank you very much, best regards,

Jürgen

Outcomes