AnsweredAssumed Answered

Calculation question

Question asked by GeraldPrager on Jan 2, 2014
Latest reply on Jan 2, 2014 by GeraldPrager


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