AnsweredAssumed Answered

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

Question asked by tmgee on Oct 28, 2014
Latest reply on Oct 28, 2014 by 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

Outcomes