Oracle Analytics and AI

Vasanthakumar Ravi

Hi All,

We have a requirement to develop the average age band in percentage by YOY and we are using below formula and it not working as expected, Please help me if you have received similar requirement in OAC.

Please refer the attached screenshot( by default it showing 100%)

CASE

WHEN "HCM - Workforce Core"."Facts - Workforce Headcount"."Average Worker Age" < 30

THEN ' < 30'

WHEN "HCM - Workforce Core"."Facts - Workforce Headcount"."Average Worker Age" BETWEEN 30 AND 39

THEN ' 30 - 39'

WHEN "HCM - Workforce Core"."Facts - Workforce Headcount"."Average Worker Age" BETWEEN 40 AND 49

THEN ' 40 - 49'

WHEN "HCM - Workforce Core"."Facts - Workforce Headcount"."Average Worker Age" BETWEEN 50 AND 59

THEN ' 50 - 59'

WHEN "HCM - Workforce Core"."Facts - Workforce Headcount"."Average Worker Age" >= 60

THEN ' >= 60'

ELSE 'Not Disclosed'

END

Subha_Tripathy-Oracle

Hi @Vasanthakumar Ravi ,

Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

This seems to be a OAC issue, Request you to log a SR under Product Oracle Analytics Cloud for further troubleshooting.

Thanks

Subha