Clean up 0 FTE, Hours, Person Days in Resource Aggregate Weekly

[hacktd]

I tried to press button Update Resource Aggregate and Update Resource Capacity. in user's form but there is no removal logic for these records with category = Project Allocated 0 FTE, Hours, Person days only for category = Project Confirmed. Is there any other logics which remove these Project Allocated ? 

[Louis Savalli]

Same question here, did you get any answer on this?  Why do those zero-hour records exist in the aggregates tables?  For example I'm seeing some resource_aggregate_monthly records that have zero hours for tasks that have no resource plans, like a demand that has since become a project.

[hacktd]

Hi @Louis Savalli ,

Actually there is a code behind this logic. Those existed zero-hour records are created from the cancelled Resource Plans and the button logic only removes when we select the range date which will be the filter in resource_allocation_daily table. If there is a record exist in resource_allocation_daily table then the system will remove 0 FTE/Hours/Person Days records in both Resource Aggregates Monthly and Weekly table. Currently that is the logic I've checked in the codes. Hope this helps even though it is a late response.