After creating a custom attribute to display total allocation hours on the Idea list page, one of the Ideas is showing an unexpected amount of 37,427 total allocation hours. Looking at the aggregation row on the team list of this same Idea shows only 70 total allocation hours.
What could be the reason for this discrepancy?
This issue will occur if there is no Start and Finish Date on the Idea. If there is no start and Finish Date on the Idea, the system does not have dates to calculate the allocation hours with, so it uses the earliest and latest dates that it can. For 15.7.1, those dates are 1900-01-01 to 2079-06-02.
The hours on the Team list do not take into account the allocation hours for team members where the allocation is calculated with these dates. Howeve, the PRTEAM table as well as any custom attribute calculating total allocation will include these hours.
In order to get the allocation amounts to calculate a smaller amount, either enter a Start and Finish Date for the Idea or the Team member. Neither of these dates are required out of the box, but they can be made required on the Attributes tab on either of those two objects to prevent them from being left blank. Note that the Team object is shared between investments, so making an attribute required on this object will impact all investments.