Summary fields not updating when constraining found set
I am using summary fields in a calculation.
I have a table with records containing a date field and a time field.
when I perform a find in a script step using the date field to get all reords from one day there is no problem using the summary fields. But then if I want to constrain the found set to find records before 4pm or records after 4 pm the summary fields don't update they keep the same values. Although when I view the records in list view the trailing totals are updated. I don't understand why those values are updating but now the values in my summary fields in my table.