3 Replies Latest reply on Sep 3, 2016 11:33 PM by Mahfooj Khan

    Сombining formulas

    Aleks Roth
    Aleks Roth Sep 3, 2016 2:59 AM

      Please help me with combining these two formulas:

      1. REGEXP_EXTRACT([resolution],'(\d{2}:\d{2})')
      2. IF CONTAINS([resolution],"closed") and NOT CONTAINS([resolution],"resolution") THEN 1 ELSE 0 END

      Example: I have lines

       

      1.resolution(01:01) Completed repair equipments

      2.resolution(01:02) Preventive maintenance

      3.The problem is not current

      4.resolution(01:03) Completed repair equipments.

      The problem is not currentI have 2 calculated field.

      1. REGEXP_EXTRACT([resolution],'(\d{2}:\d{2})') - find numbers 01:01,01:02,01:03
      2. IF CONTAINS([resolution],"closed") and NOT CONTAINS([resolution],"resolution") THEN 1 ELSE 0 END - excludes records:3.The problem is not current

      I want to make a formula which combined two formulas and displays numbers:01:01,01:02,01:03

        • 1. Re: Сombining formulas
          Mahfooj Khan
          Mahfooj Khan Sep 3, 2016 7:46 AM (in response to Aleks Roth)

          You can try something like this

          Hope this help.

           

          Mahfooj

          • 2. Re: Сombining formulas
            Aleks Roth
            Aleks Roth Sep 3, 2016 8:42 PM (in response to Mahfooj Khan)

            Hello, thank you for your help.

            Sorry, I'm not completely write an example.

            Line: 3."The problem is not current" must be extracted from the group NULL.

            Line:1,2,3,4 are typical examples,  but there are also has other lines that diferent from lines:1,2,3,4

             

            Example:

            5. software install failed

             

            6. windows install not successful

             

            lines 5,6 must be included in group NULL.

             

            I want to get a formula which will bring the table below:

             

            RESOLUTION                                       COMBINED

             

            resolution(01:01) Completed repair equipments,    01:01

             

            resolution(01:02) Preventive maintenance,        01:02

             

            resolution(01:03) Completed repair equipments. The problem is not current, 01:03

             

            software install failed, NULL

             

            windows install not successful,NULL

            1 of 1 people found this helpful
            • 3. Re: Сombining formulas
              Mahfooj Khan
              Mahfooj Khan Sep 3, 2016 11:33 PM (in response to Aleks Roth)

              The formula only brings you the extracted values from your [Resolution] field. To filter out Line3 from the result set the easiest you is just put a filter on your [Resolution] field and exclude the Line3.

               

              Or you can create a calculated field to filter line 3. Drag the field in filters shelf and select True.

              Hope you get my point.

               

              Mahfooj

              1 of 1 people found this helpful