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