Age Bins

Summary

Invalid Alias Format

Content

Hi,

I've copied a formula that calculates the age of an employee from the following Oracle video:

The only difference in my version is that the date of birth is prefixed by Person not Employee and I have a sub folder called 'Parent Managers'

My organisation= "Worker"."Parent Managers"."Person Date of Birth"

in the video it is = "Worker"."Employee Date of Birth"

Why am I getting the following error message? 

Error Message: Invalid Alias Format : Table_name.Column_name required. OK (Ignore Error)

The SQL is below.

Thanks,

Andrew

Version

19D

Code Snippet

CASE WHEN
TIMESTAMPDIFF(SQL_TSI_DAY,CURRENT_DATE,TIMESTAMPADD(SQL_TSI_DAY,CURRENT_DATE,TIMESTAMPDIFF(SQL_TSI_YEAR,
"Worker"."Person Date of Birth",CURRENT_DATE),"Worker"."Person Date of Birth"))
>=1 THEN TIMESTAMPDIFF(SQL_TSI_YEAR,"Worker"."Person Date of Birth",CURRENT_DATE)-1
ELSE TIMESTAMPDIFF(SQL_TSI_YEAR,"Worker"."Person Date of Birth",CURRENT_DATE)END