Contains() Giving Strange Results

348
1
11-26-2018 02:43 PM
deleted-user-AHEapLrN7M1u
New Contributor II

Ismael Chivite

James Tedrick

I am getting some interesting behavior when using a contains() function. I want to make a field relevant only if at least one of the records in a repeat has a  specific value. Ideally I would use a formula like contains(sum(${field_of_interest),'no') which should return a value of true if any of the repeat record has a value of 'no' in the field_of_interest field. This is not the case and my contains function always returns true, even if the function is given as contains("A","B").

I have attached some screenshots of the survey I was using.

Any help is appreciated!

P.S. Please disregard the SITE_ID field, it is populated from a pop-up window in a AGOL web-map.

0 Kudos
1 Reply
JamesTedrick
Esri Esteemed Contributor

Hi Matthew,

I'm not seeing the results you are describing - the contains() function seems to work properly (in your form, I both the contains("A","B") and contains(sum(${Test}),"no") functions work).

0 Kudos