Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
How to exclude 2018 Apr? I already try to minus 20 days from today's date, but it didn't works.
Please help. Thanks.
Hi Rachel,
I get your points. i modify it to be like this. its working now. Thanks.
=Num(Count({$<Status={'Completed'}>*$<[PSR No]-={"''"}> *$<Temp={'Task_W'}>
*$<[Modified Date]={">=$(=AddMonths(MonthStart(Today()),-12))"}>
*$<[Modified Date]={"<$(=MonthStart(Today()))"}>
} ([PSR No])),'##.0')
Try something like this:
<[Modified Date]={">=$(=AddMonths(MonthStart(Today()),-11))"}, [Modified Date]={"<=$(=MonthStart(Today()))"}>}
Essentially it is adding another conditioning saying that the date should be less than the start day of the current month.
Hi Rachel,
I get your points. i modify it to be like this. its working now. Thanks.
=Num(Count({$<Status={'Completed'}>*$<[PSR No]-={"''"}> *$<Temp={'Task_W'}>
*$<[Modified Date]={">=$(=AddMonths(MonthStart(Today()),-12))"}>
*$<[Modified Date]={"<$(=MonthStart(Today()))"}>
} ([PSR No])),'##.0')