Need to calculate Age in BI Analysis
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?
3