I have a portal filter setup and a self-join summary field on the table to place a summary of the day's hours in a global variable.
In my portal filter script, I am setting the summary to only include records that meet the criteria of of the EMPLOYEE ID and the DATE of the entry.
PORTAL FILTER SCRIPT: Let($$dayhrs04=Punches::sumDayHrs;Punches::date = $$day04 and Punches::employee_idf=$$employee_id)
This script works perfectly by not including any data from any other record EXCEPT the very last record (whether the record is in a prior or future date. Also, portals without any dated entries will display the very last record as well.)
Any suggestions would be appreciated.