Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please Help me, I want search total population employee with, but how can I make the name of the new employee in the following month not appear so that every time I choose a month, the population will appear that month, this formula that I use but is not yet valid
=Count(DISTINCT{<year = ,month = ,status = ,MQ = ,Product = ,[Employee Status]={'*'}-{'Non Active'} >}Populasi)
this is a formula that only raises employees not logged in that month and for the next new employee it still appears. how to prevent new employees from appearing next month. Take my example in February but new employees in March and April also appeared:
=Count(DISTINCT{<year = ,month = ,status = ,MQ = ,Product = ,[Employee Status]={'*'}-{'Non Active'}>}Populasi)-count(DISTINCT idnumber_fto)
Thank you
Hello, This is what I want expected result 😊
Hello.,
Take stright table and
diemsion As Month and
Expression as Count of emp
Do you have the join date detail in your table?
Allready, but the new emp id still calculate
Can you please populate the join date detail into the sample excel as well?
May be this
=Count(DISTINCT{<year, month = {"<=$(=Max(month))"}, status, MQ, Product,[Employee Status] = {'*'}-{'Non Active'}>} Populasi) - Count(DISTINCT idnumber_fto)
Here I am assuming that month is defined as a number in your script based on the sample provided
Still not work and error .... 🤔