I have a process (run from scheduling) that needs to calc an average for each instance in the vendor object. Based on the below code, I would have expected this AVG calc to run separately for each Vendor put into context from the FIND action.
FIND ALL Vendor
Vendor.AverageRating=AVG ProjectVendor.PerformanceRating WHERE (ProjectVendor.Vendor=Vendor)
What actually happens is that when the process runs, the calc computes the AVG based on the first vendor found, and then applies the result to all vendors. I need the calc applied separately for each vendor in the context.
Since AwareIM has no looping construct that I can find, I coded using a single FIND.
