AnsweredAssumed Answered

Substitute Calculation "Contains" vs "Equals"

Question asked by lindseym on Dec 29, 2016
Latest reply on Dec 30, 2016 by lindseym

Howdy Folks:

 

Working on calculation and I ran across this issue. I can't seem to figure out how to do a  Case + substitute calculation when my test does not = something specific.

 

Here is what I have:

 

Screen Shot 2016-12-29 at 3.28.38 PM.png

 

 

 

 

 

${Copy (Side A)} ? "LEVEL#" ; Substitute ( ${Copy (Side A)} ; "LEVEL#" ; Level from Space ) ;

 

What I am looking for is:

 

${Copy (Side A)} contains but does not equal  "LEVEL#" (performed in the first test of case) it performs the substitution. I have the substitute calculation working fine, just not sure how to do an operator of "contains" within a case calculation.

 

-------------------------------

 

 

I realized that I could just use ≠ .... but because the case function goes down the list until it evaluates true it would stop at that test. I want it continue down the list if "LEVEL#" isn't contained in the field.

 

Any thought on the best way to do this?

 

 

 

 

 

Working on FMP 14.0.6

 

Thanks

-L

Outcomes