Creating new column<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />I am trying to create a column titled >2 Exac from the following example data set.
| Patient | Exac/yr | >2 Exac |
|---|
| 234 | 1 | 1 |
| 234 | 2 | 1 |
| 234 | 5 | 1 |
| 234 | 1 | 1 |
| 235 | 1 | 0 |
| 235 | 1 | 0 |
| 235 | 1 | 0 |
| 236 | 3 | 1 |
| 236 | 1 | 1 |
| 236 | 1 | 1 |
| 236 | 1 | 1 |
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?
Re: Creating new columnA column formula is easy and will stay updated when adding, editing or deleting rows.
Col Maximum(:Name("Exac/yr"), :Patient) >= 2
