calculate the past experience in HCM BI Report
Summary:
calculate the past experience in HCM BI Report
Content (required):
My client requirement is to calculate the past experience and current organization experience. if any having the similar report, could you please share me the report please.
Previous years experience I am taking from profiles and current org experience I am taking from the per_seniority_dates_f table. I looking for a logic to get if person is having any gaps in between the past experience.
Version (include the version you are using, if applicable):
23B
Code Snippet (add any code snippets that support your topic, if applicable):
0