formula question

DanBonn

I have a formula that is working fine, but i want to squeeze in one more logic variable. I am looking at thousands of rows of data. I want the formula to count any row with column value of [stay level] of "medical" or "emergency medical", then for the five facilities listed i also want the formula to also bring in all rows with a [stay level] of "Observation".

=IF(OR(AND([Facility Name]@row = "Corpus", [Stay Level]@row = "Observation"), AND([Facility Name]@row = "Doctors Hospital", [Stay Level]@row = "Observation"), AND([Facility Name]@row = "Medical Center", [Stay Level]@row = "Observation"), AND([Facility Name]@row = "Methodist Center", [Stay Level]@row = "Observation"), AND([Facility Name]@row = "South Health", [Stay Level]@row = "Observation"), [Stay Level]@row = "Medical"), 1, 0)

DanBonn

Thanks. Completed this by adding a helper row to combine the medical and emergency medical stay levels into one value.

DanBonn

Thanks. Completed this by adding a helper row to combine the medical and emergency medical stay levels into one value.