Fusion OTBI - Performance Tiles Percentage
Summary
Fusion OTBI - Performance Tiles PercentageContent
Hello
I am actually a bit embarrassed to post this as I should surely have been able to work it out myself...
But, part of the joys of being a co-existence customer without full fusion (we use EBS, Fusion, and Taleo Recruit) is that we are missing a number of columns of data, a fairly key one is that Headcount is not transferred from EBS to Fusion (we do transfer FTE though), so to show headcount we use; COUNT(DISTINCT "Worker"."Person Number") so not to much of an issue.
However to show Part-time headcount I then need to use; CASE WHEN "Worker Assignment"."Full-Time Equivalent" < 1 THEN COUNT(DISTINCT "Worker"."Person Number") END