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
What is the error you are getting?
Hello this is table populasi for formula, help me because the formulas still not work
see a attachment, this is my table population
What was the error message that you got?