BI Publisher and Person FTE
Summary
Having issues with FTE in work measures and UNITContent
Hi All, I am writing a report and i need to bring back person FTE so i am bring back value and unit from the PER_ASSIGN_WORK_MEASURES_F table and then filtering out so it only brings back unit = 'FTE'
However my problem occurs as we have volunteers who have 0 FTE but need to come back in the report. some of these volunteers have their value as 0 but the unit is HEAD so when i filter to only 'FTE' they don't come back in the report. I tried a CASE WHEN to change the HEAD TO FTE which brings them back but i get another issue in that some part time staff have an FTE and a HEAD so they bring back two lines for their two different values.