You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to calculate Age in BI Analysis

Accepted answer
177
Views
6
Comments
edited May 17, 2017 3:59PM in Reporting and Analytics for HCM 6 comments

Summary

What is the formula needed to calculate age within a BI Analysis?

Content

I am trying to complete a report to calculate the age levels of employees.  I pulled in headcount, and Date of Birth 3 times.  In the second Date of Birth column, I changed the expression to reflect the Current Date.  In the third Date of Birth column I tried to create the formula as I would in Excel: INT((Current Date-Date of Birth)/365).  The INT expression doesn't seem to be available as a function in BI Analysis and I get a formula syntax error when I attempt to run it.  Is there another way to write this formula?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!