5 Replies Latest reply: Jan 30, 2018 8:28 AM by Bram Knuever RSS

    Mid function

    Sofia Vaz

      Hi all,

       

      In a set analysis want to consider all ProdMktOrc whose 2nd position equals A, 1, 6 or 7. In order to do it, I've written the expression bellow in my set expression:

       

      ProdmktOrc={"$(=if(Mid(ProdmktOrc,2,1)='A' or Mid(ProdmktOrc,2,1)='1' or Mid(ProdmktOrc,2,1)='6'or Mid(ProdmktOrc,2,1)='7', ProdmktOrc))"}

       

      The expression is not working... Can you help find why?

      Thank you!

       

      Sofia Vaz