BookmarkSubscribe
Choose Language Hide Translation Bar
jstewart
Community Trekker

Creating new column

I am trying to create a column titled >2 Exac from the following example data set.

PatientExac/yr>2 Exac
23411
23421
23451
23411
23510
23510
23510
23631
23611
23611
23611

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?

0 Kudos
1 REPLY 1
ms
Super User ms
Super User

Re: Creating new column

A column formula is easy and will stay updated when adding, editing or deleting rows.

Col Maximum(:Name("Exac/yr"), :Patient) >= 2

0 Kudos