Question about the max function and missing value

Hello to all,
I am measuring 3 values of blood pressure and I would like to get the top higher value between the 3. Easy. The thing is what happen is we get some missing values?
How can we get a formula that will take into account the non-missing values only?
So ar, my formula needs to have the 3 values, If i leave as black one value, it does not work.
Any idea
Thank you in advance for your help
ps my excel in attached fileblood_pressure_AP.xlsx (9.3 KB)

You could do it as outlined in the image shared below.

In the survey tab of your xlsform:

Data entry screen as seen in Enketo: when all the variables are filled

Data entry screen as seen in Enketo: when some of the variables are missing

Reference xlsform:

Maximum.xlsx (9.7 KB)

Thank you so much I really appreciate your help and your quick response as always! Thank you!
another question will have to face one one of my questionnaire soon.
For instance let us keep measures of blood pressure, example we run the measurement 10 times, I would like to have the maximum, and the second highest value and the third highest one out of 10. How can I do (still with possible missing values I suppose using coalesce.
Thank you
have. a nice day

Maybe this post discussed previously should solve your issue:

Thank you again very helpful!
I do not know what I will do without you

1 Like