Subscribe Bookmark RSS Feed

Creating new column

jstewart

Community Trekker

Joined:

Jan 10, 2012

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?

1 REPLY
ms

Super User

Joined:

Jun 23, 2011

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

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