Crow Canyon Software Forum
Sum Aggregrates Not same
Quote from skigeek on October 24, 2023, 2:34 pmI have an association column where I have a sum aggrerate on a total cost for travel. It appears on the bottom of the association and is correct. And I put the total in a column in the list. (EstTotalTripCost). Everything works really well, until I have a custom action that actually removes one of the associated rows. When this and I refresh the form, the value at the bottom of the list is updated correctly but the total that is stored in the list does not get updated... How can I update it? I know that if I refresh the association from the form it will refresh the column. But if I run a report or just go into the form and not refresh, the value is the old one before the custom action was run.
I have an association column where I have a sum aggrerate on a total cost for travel. It appears on the bottom of the association and is correct. And I put the total in a column in the list. (EstTotalTripCost). Everything works really well, until I have a custom action that actually removes one of the associated rows. When this and I refresh the form, the value at the bottom of the list is updated correctly but the total that is stored in the list does not get updated... How can I update it? I know that if I refresh the association from the form it will refresh the column. But if I run a report or just go into the form and not refresh, the value is the old one before the custom action was run.
Uploaded files: