segmentation cohorts

[jos818]

Hi, below table shows a patients table with either 0 or 1 across each of a long term health condition. (Assume 1 = diagnosed with the condition, 0 = not diagnosed)

I need to create a calculated column (returning either Y/N or 1/0 to flag the following criteria);

Any patient who only has 2 or more of the 3 conditions: QoF Depression, QoF SMI and QoF Dementia without any of the other (physical) conditions.

can you assist?

[amitchandak · Accepted solution]

@jos818 , You need to have column like , Assuming all are column

if( ([QoF Depression]+ [QoF SMI] +[QoF Dementia]) >=2 && ([QoF Epilese]+ [QoF Cancer] +[QoF Hart Failure])  =0,1,0) 

In part two in bold add all the illnesses you want other the first three