Problem finding Process Error

customaware

I keep getting this error for a particular process at runtime.....

"Unable to find LeaveAssignment.EndDate in aggregate operation SUM"

So the problem attribute is as Bolded below.

I have already tried This and That to no avail.
I cannot see any reason it canot find LeaveAssignment.EndDate when it must be finding LeaveAssignment.StartDate

Can anyone spot where Wally is please?

The process is as follows....

CONDITIONS:
If Enquiry_Date_NP.Enquiry_Date=CURRENT_DATE Then

ACTIONS:
FIND LeaveAssignment WHERE LeaveAssignment.OB_RegularUser.DisplayName=RegularUser.DisplayName IN BATCHES OF 1

LeaveAssignment.UsedToCURRENT_DATE=SUM AbsenceApplicationEvent.EventDays_Temp WHERE
(
AbsenceApplicationEvent.OB_Application.SC_EmployeeName=RegularUser.DisplayName AND
AbsenceApplicationEvent.OB_Application.Status<>'CANCELLED' AND
AbsenceApplicationEvent.P_LeaveType IN LeaveAssignment.P_LeaveType AND
AbsenceApplicationEvent.TempEndDate<=Enquiry_Date_NP.Enquiry_Date AND
(
(
LeaveAssignment.EndDateDefined='Yes' AND
(
AbsenceApplicationEvent.TempEndDate<LeaveAssignment.EndDate OR
LeaveAssignment.SaldoMode='Yes'
)
) OR
(
LeaveAssignment.EndDateDefined='No' AND
AbsenceApplicationEvent.TempEndDate>=LeaveAssignment.StartDate
)
)
)
+LeaveAssignment.CarryOverUsedDays

LeaveAssignment.UsedToENQUIRY_DATE=LeaveAssignment.UsedToCURRENT_DATE

kklosson

When doing a FIND like this, it is sometimes better to call a process for the individual actions. So try putting your actions into another process and just call the process after the FIND statement. I'm not just guess. I believe I have experienced this. Not a bug, just how it seems to works.