Categories
- All Categories
- 101 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 4 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Tenure calculation in OTBI

Summary:
Used Current_Date function & Enterprise Seniority Date field to calculate Tenure (in a separate field) however the result is not accurate (its showing value zero for some colleagues). Can someone help me understand what additional criteria do I need to use to calculate it correctly please
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Hi Abhishek,
Would you give some more details like what Tenure you are looking to calculate here? Perhaps you can attach your report xml / catalog if that's better.
Cheers,
0 -
Thanks for your response.
Below shared is the calculation i tried - using CURRENT DATE function & Seniority Date field (to calculate in time tenure).
Hope below snap helps understand about my query better.
Regards,
Abhishek
0 -
Hi @Abhishek Bagh ,
The formulas are really interesting, thanks for sharing.
Would you mind using formula like below?
Values will be on Float:
CAST(TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Enterprise Seniority Date", CURRENT_DATE) AS FLOAT) / 365
without decimal:
TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Enterprise Seniority Date", CURRENT_DATE) / 365
Hope this help.
Cheers,
0 -
0
-
Glad it worked for you.
Would you mind selecting the best answer that resolved your issue so that it'll help fellow community members in future?
Cheers,
0 -
In my case, below one worked quite well. Thanks again!
CAST(TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Enterprise Seniority Date", CURRENT_DATE) AS FLOAT) / 365
Regards/ Abhishek
1 -
Hi - Is there a formula that would provide Years of Service for current year? All the formula's above supply information based on current date and I am in need of for entire year.
1 -
Hi @Abhishek Bagh - thank you for the explanation! I also used the formula above to calculate tenure and it worked. I used Enterprise Hire Date rather than Enterprise Seniority Date since I wanted years of service since employee started with the company.
Thanks again.
0