Two true statements add up to a false???

Discussion created by carolej on Nov 20, 2018
Latest reply on Nov 21, 2018 by carolej

Hello -


I'm trying to enter this field validation for the field Funding Source_CountyOf field using this:

PatternCount (Funding Source ; "County of" > 0 ) and FundingSource_CountyOf = $Null


When the funding source contains the value "County of" (there can be multiple values), the other field FundingSource_CountyOf cannot be empty. When the two parts of this statement each result in 1 (i.e. true) when analyzed separately in the Data Viewer, together they equal zero (false).


How can this be?