2 Replies Latest reply on Jan 2, 2014 5:02 PM by GeraldPrager

    Calculation question



      Calculation question


           I am trying to put together a calculation which tells me if a word is in a field it will return a 0 and if its not it returns a 1.


           Field Name: Project:  If the  contents have the word Travel the result is a 0

           Project:(Cedarburg Library) it returns a 1

           Project:(Cedarburg Library Travel) it returns a 0    

           It could look like this as well

           Project: (Cunningham) it returns a 1

           Project: (Cunningham Travel) it returns a 0

           Any help would be appreciated