3 Replies Latest reply: Feb 21, 2018 6:46 AM by Anderson Américo RSS

    Set analysis with string function

    souad ouertani

      HELLO

      I didn't found the error in this expression :

       

      =count({<DATE={'<= $(DATE_EXT)'}, DATE_OUVERTURE = {'=RIGHT(DATE_OUVERTURE,2)) = RIGHT($(ANNEE_EXTRACTION),2) '}>}id)

        • Re: Set analysis with string function
          Anderson Américo

          hi

           

           

          at first it seems to me that there is something missing in the highlighted part of the expression.

           

          =count({<DATE={'<= $(DATE_EXT)'}, DATE_OUVERTURE = {'=RIGHT(DATE_OUVERTURE,2))

          = RIGHT($(ANNEE_EXTRACTION),2) '}>}id)

          • Re: Set analysis with string function
            Tresesco B

            Not seeing an error (rather, an error highlighting), doesn't guarantee that the expression would give you expected output. It only indicates that, in someway the expression could be parsed to a a valid syntax. And to identify why your expression not working per se, would require more information. Could you share a sample file?

            • Re: Set analysis with string function
              Sunny Talwar

              May be these few things

               

              1) Don't have space between >= and your dollar sign for set modifier for DATE

               

              2) Use double quotes for search strings

               

              3) May be you need an equal sign for the dollar sign expansion

               

              =Count({<DATE = {"<=$(=DATE_EXT)"}, DATE_OUVERTURE = {"=Right(DATE_OUVERTURE, 2)) = Right($(ANNEE_EXTRACTION), 2)"}>} id)

               

              or this

               

              =Count({<DATE = {"<=$(=$(DATE_EXT))"}, DATE_OUVERTURE = {"=Right(DATE_OUVERTURE, 2)) = Right($(ANNEE_EXTRACTION), 2)"}>} id)