Contains formula returns 0 and -1

[LinhNguyen]

Hi,

I'm using the contains formula and instead of giving 0 and 1 (or False and True), it's giving 0 and -1, and it returns -1 when a "True" is expected.

For example: contains("one","e") returned -1

Could you let me know if this is an erorr or if it's normal? Why was it set up this way?

Thank you,

Linh

[JosephSerpis · Accepted solution]

Hi @LinhNguyen that is expected behavior when you are working with a string field. If you changed the data type to boolean in the formula tool you are using with the contains formula than it would be 0= False and 1= True. This post helps to explain the rationale behind this.

[LinhNguyen]

Thank you! turning the field into boolean made it True/False 🙂