You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Calculating Past Experience of employees in HCM BI

Accepted answer
106
Views
3
Comments
edited May 19, 2020 9:34PM in Reporting and Analytics for HCM 3 comments

Summary

Calculating Past Experience of employees in HCM BI

Content

Hi;

I was trying to calculate the total past experience of the employee in BI with the below formula but getting wrong results for some employees. The subject area being used is

Workforce Profiles - Person Profile Real Time

CAST(TIMESTAMPDIFF(SQL_TSI_YEAR, "- All Profile Content"."ItemDate1", "- All Profile Content"."ItemDate2")  AS CHAR(10)) || 'Years ' || CAST(ABS(CAST(SUBSTRING(CAST("- All Profile Content"."ItemDate1"  AS CHAR(10))  FROM 6 FOR 2) AS INT) - CAST(SUBSTRING(CAST("- All Profile Content"."ItemDate2"  AS CHAR(10))  FROM 6 FOR 2) AS INT)) AS CHAR(10)) || 'Months'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!