I need to figure out how to filter the Employee Rate table Amount field so that the only figure that is returned is the most recent Rate. We keep history of all rates that an employee has had so we have several lines per employee in many cases. Can the filter be on the Date or the Amount? thanks for any help.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
You should be able to sort by the Date and then return the last value:=NL("Last","Employee Rate","Amount","+Date","*","Employee Id",[your employee id])
I'm assuming you're probably replicating employees with NL(Rows) and then filtering on the employee id to get the most recent rate for each employee. Does this help?
Regards,
Hughes
Please sign in to leave a comment.