Calculation: Search text string, if Field1 contains "BO", then Field2 = ".01"
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?