Counting Formula problem...
I'm trying to get a calculation to work and am having some trouble. Can anyone take a look and see what I am missing?
Each record has counts for available ambulances in 3 zones (North, South, East). For the 3 zones, there 3 different values that would equal the zone (North could = AC_North_Wilderness or AC_North_Rural or AC_North_Urban Same for South and East) and I am trying to get this formula to return a 1 if the count in a Zone has a negative number if the record took place in that zone only (field for that is Response_Area1). The Formula I've put together returns a 1 if any of the zones has a negative value.
If (Response_Area1 = "AC_North_Urban" or Response_Area1 = "AC_North_Rural" or Response_Area1 = "AC_North_Wilderness" and Sys.lvl.N < 3; 1; 0) or If (Response_Area1 = "AC_South_Urban" or Response_Area1 = "AC_South_Rural" or Response_Area1 = "AC_South_Wilderness" and Sys.lvl.S <5; 1; 0) or If (Response_Area1 = "AC_East_Urban" or Response_Area1 = "AC_East_Rural" or Response_Area1 = "AC_East_Wilderness" and Sys.lvl.V < 3; 1; 0)
Any help would be great! Thanks in advance.
Point of clarification, not looking for a negative number but if Sys.lvl.* is less than the specified number it should return a 1. Sys.lvl.N = North and so on.