I am trying to create a column titled >2 Exac from the following example data set.
If any row for a particular patient is greater than or equal to 2 then I want to place a 1 in the new column (>2 Exac) for that patient (for each entry in the database).
If no row for a particular patient is greater than or equal to 2, then I want to place a 0 in the new column for that patient.
What is the easiest way to do this?
A column formula is easy and will stay updated when adding, editing or deleting rows.
Col Maximum(:Name("Exac/yr"), :Patient) >= 2