Age calculation on As-Of-Date
SummaryWe need to build a report which shows the age of Worker on As-Of-Date
We need to build a report with As-Of-Date variable so that it would also calculate the age of Worker on that day. We need to report Grade distribution per age category. I have created OTBI report with As-Of-Date parameter but struggling to get age calculation working with the parameter. The issue comes with TimestampDiff function when trying to replace CURRENT_DATE with @AsOfDate. Attached the XML.
Do you have any other ideas how to solve this in OTBI?