How to calculate the smallest value and equal value in two select?

User Support Form Building
, , ,
1

@Kal_Lam
@wroos
Please help
Hello Namasate,
How to calculate the smallest value and equal value in two select
Patient_Eye_Survey.xlsx (15.2 KB)
questions ?

2

Here are 2 solutions:
02Patient_Eye_Survey.xlsx (14.7 KB)
03Patient_Eye_Survey.xlsx (14.6 KB)

The second one uses a calculated read_only select, instead of a note. This may be better for data export, as you get the standard code/label option.

I changed your note to show the label of the minimum, instead of the code (name).

1 Like
3

@wroos
Thank you very much.

1 Like