Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a straight table displaying records within a given date range. I would like to display ONLY the latest record prior to a user-defned "as of date". To identify this record, tried:
If(Aggr(NODISTINCT Max({<EFFECTIVE_START_DATE={"<=$(=vAsOfDate)"}>} EFFECTIVE_START_DATE), EMPLOYEE_NUMBER) = EFFECTIVE_START_DATE, 1,null()),
However, all records return a null. I'm not sure that my set expression in the MAX function is correct. Any assistance would be appreciated.
Would you be able to share some sample data points with your desired output?