1 Reply Latest reply on Aug 13, 2009 8:22 AM by philmodjunk

    Calculated Value

    jdhelle

      Title

      Calculated Value

      Post

      I'm sure this is really simple, but I'm not able to figure it out.  I'm using:

       

      If ( Medium = "Blue Amberol" and Created_From_Orig_Rec#_BA_PA_Only  ≠  ""; "Dubbed" ; "Direct" ), which works great.  My problem is Medium can be either "Blue Amberol" or "Royal Purple Amberol" - I can't make it check for both.

       

      Thanks in advance! 

        • 1. Re: Calculated Value
          philmodjunk
            

          Option 1:

           

          If ( ( Medium = "Blue Amberol" or Medium = "Royal Purple Amberol" ) and Created_From_Orig_Rec#_BA_PA_Only  ≠  ""; "Dubbed" ; "Direct" )

           

           

          Option 2:

           

           

          If ( Patterncount (Medium, "Amberol") ≠  0 and Created_From_Orig_Rec#_BA_PA_Only  ≠  ""; "Dubbed" ; "Direct" )