Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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])
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'