2 Replies Latest reply: Feb 14, 2018 10:16 AM by Digvijay Singh RSS

    How to combine this two formula?

    ahmad albab

      Hi. Any idea on how to make it one expresion? Thanks.

       

      First formula

      =  '= '  & (num((count (if( [Date Created] >  MakeDate(2018,1,15) and

      Status='Completed'and [SR No]<>('') and Temp=('Task_2')  and

      [Date Modified.autoCalendar.YearMonth]>= (AddMonths(MonthStart(Today()-20),-11))

      ,[SR No]))),'##.0')) &' task'

       

      Second formula

      =if(Temp='Task_1' and Min([Date Created]>MakeDate(2018,1,15)),[SR No])

        • Re: How to combine this two formula?
          youssef belloum

          Hi,

           

          you just want to concatenate these two expressions to see the result in one line ?

           

          if they already works, just link them by an & like this:

           

          =  '= '  & (num((count (if( [Date Created] >  MakeDate(2018,1,15) and

          Status='Completed'and [SR No]<>('') and Temp=('Task_2')  and

          [Date Modified.autoCalendar.YearMonth]>= (AddMonths(MonthStart(Today()-20),-11))

          ,[SR No]))),'##.0')) &' task'&if(Temp='Task_1' and Min([Date Created]>MakeDate(2018,1,15)),[SR No])

          • Re: How to combine this two formula?
            Digvijay Singh

            May be like this -


            =  '= '  & (num((count (

                if(      [Date Created] >  MakeDate(2018,1,15) and

                          Status='Completed'and [SR No]<>('') and

                          (Temp='Task_2' or  (Temp='Task_1' and Min([Date Created])>MakeDate(2018,1,15))) and

                          [Date Modified.autoCalendar.YearMonth]>= (AddMonths(MonthStart(Today()-20),-11)) and

                            Temp='Task_1' and Min([Date Created]>MakeDate(2018,1,15))

                          ,[SR No],

            ))),'##.0')) &' task'