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



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,