4 Replies Latest reply on Oct 28, 2014 8:31 AM by tmgee

    Calculation: Search text string,  if Field1 contains "BO", then Field2 = ".01"

    tmgee

      Title

      Calculation: Search text string,  if Field1 contains "BO", then Field2 = ".01"

      Post

       

      Hello FM Forum,

      I'm sure this has been covered in these forums but I cannot find what I need.

      I have Field1 which contains a Text entry of product codes (i.e. BOTH000225).

      I have Field2 which needs to contain a Numeric value based on what is entered in Field1

      I need to write an Auto-Enter Calculation that will fill FIeld2.

      Here's what I have tried:

      Case ( (PatternCount (FIELD1 ; "BO")=1)  ; ".01")

      I'm using FMA 13

      I'm certain I am missing something.  Can someone lead me to the FM promise land?

      Thank you!

      Todd