I want to sum records that have a certain date. The records are in a portal with 5 different fields. Need to have a sum on one of the fields . Can not seem to accomplish that. It seems to sum all the records and not just the ones I want.
Any ideas would be appreciated.
For example the fields I want to sum is the cost associated with records for a certain date. The best I could do is sum all the records regardless of the particular date I need.
Set a variable that allows you to locate the portal records, new window, go to the portal source table, do a find with your variable and the date you want, add the results into a variable, close the window, put the sum variable wherever you like.