Calculating Past Experience of employees in HCM BI

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'