Adjustment in Previous Month Count

[sunil-kumar5]

Hi Community,

I was showing the numbers of separated employees for previous month now I have to put one condition that if EMP_Status = LWP than it does not come under the count.

current using expression for last month count:- Count({<LYear={'$(=Year(Today()))'}, LMonth={'$(=Month(Addmonths(Today(),-1)))'}>} distinct EMP_CODE )

Please advise..

Thanks

[PriyankaShivhare]

 Count({<LYear={'$(=Year(Today()))'}, LMonth={'$(=Month(Addmonths(Today(),-1)))'},EMP_Status = -{'LWP'}>} distinct EMP_CODE )

[MayilVahanan]

Hi @sunil-kumar5 

For 2021 Jan, your expression will be like  LMonth = Dec  & LYear = 2021 and display zero values. 

So change the formula like below

Count({<LYear={'$(=Year(Addmonths(Today(),-1)))'}, LMonth={'$(=Month(Addmonths(Today(),-1)))'}, EMP_Status -={'LWP'}>} distinct EMP_CODE )

[sunil-kumar5]

Thanks for the response, later on I was able to adjust it properly.

[sunil-kumar5]

Thanks for the advise Mayil, I didn't realize that next year I have to make correction in my KPI's