Hi @Mallikarjuna Kuppauru-Oracle thank you for your response. Rgds Scott

thank you @ashish.f.singh-Oracle

Hi @Sumanth V -Oracle , This is a different question to the other thread, and I raised this question as advised by @JohnW-Oracle. The other tread is about calculating Headcount at a point in time and this thread is about calculating a rolling headcount. Thanks Scott

Hi @JohnW-Oracle Thank you for your help I will proceed to raise another question. Thanks Scott

Hi @JohnW-Oracle Thank you for your response, it was spot on see below (Fig 1.), and I was able to calculate the Headcount by Using Enterprise Period End Date. However, this has provided me with a new issue whilst attempting to write a calculation using PERIODROLLING I can't achieve the desired outcome (Fig 2.). I was…

@Orange Thank you for your assistance, this has worked. Regards Scott

Hi @Mallikarjuna Kuppauru-Oracle I am not sure what you mean, I have extracted all and concatenated but am struggling to revert to a date field. Note: I add a bit more info in initial query. Thanks Scott

Hi @Rajesh L-Oracle It is more the use of Enterprise Period and when the termination date falls on the last day of the month it count the termination in the following period. (see image below: Noting that the two terminations which occur on 29/02/2024 are being counted in Mar-2024 Enterprise Period.) When you utilise…

Hi @Mallikarjuna Kuppauru-Oracle , I have reviewed the SQL and it does not seem to group by, even though I have added factors in Category section. Would this be something I would need to lodge a ticket to get support to better understand? Thx Scott

Hi @Mallikarjuna Kuppauru-Oracle I have attached images and further information in the attached document. Rgds Scott

Hi Arjun @Mallikarjuna Kuppauru-Oracle , Thank you for your response, unfortunately I am not sure on how verify the SQL from a workbook in Fusion. I agree with you though on the Grouping, as when I select multiple Factors which is how I am grouping (Category) the values increase based on number of factors selected. Any…

Hi Arjun @Mallikarjuna Kuppauru-Oracle , Thank you for your response, I am still experiencing an issue when I attempt to utilise User(). Example: I have a workbook where I am using Workforce Core and also imported some excel data. I am trying to populate a field which will return the Person Display Name from Workforce Core…

@Subha_Tripathy-Oracle Thank you for responding, I raised a SR and the issue is now resolved. I had not applied Current Day filter. Thank you

Hi @Subha_Tripathy-Oracle Thank you for your response. Whilst this information is very helpful it does not actually supply which attribute/field is being used to calculate a specific metric. One of the key problems I have is that I want to know how Tenure is being calculated as a prebuilt metric, specifically which start…

Hi @RichardChan yes, I have Head Count from Worker Assignment Real Time and Person Count from Person Real Time. Thx Scott