How to combine this two formula?

[Anonymous]

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])

[YoussefBelloum]

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])

[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'