Possible displaying bug: RMW: Total capacity within a group is calculated wrong

Adrianadrian
Tera Contributor

Hi all! 🙂 Got an issue here I hope anyone know something about. Highly appreciated! 🙂

In the Resource Board within RMW there is a significant difference between the total capacity for a group compared to summing up each users capacity within the same group. This is something we think is a relativtly large problem as it confuses and leads to misleading information, unless it is a logical explanation why this is happening, or there are some configuration that are missing, we hope this could be solved.

In the example below where this issue is discovered, for e.g month of july:

  • Each user has 172.5 hours capacity which is clearly stated when clicking into the Resource Board (see picture),
  • This is the same for all four users. Summing all 4 users gives us a total of 690 hours of capacity.

Issue/bug: However, when clicking into the group, it states that the group capacity is 660 hours. Tis means there is a discrepancy of 30 hours, which is significant and misleading.

Our question is: Does anyone know how the total capacity for the group, as shown in the picture below, is calculated? Or why we are experiencing this issue?

Adrianadrian_0-1751495360465.png

 


Other information:

The group has 4 users with the same schedule, and the UI action "Update Capacity" has been performed.

 

We have checked the tables resource_aggregate_monthly and sn_plng_att_core_attribute_based_resource_aggregates, which show exactly the same: 172.5 hours of capacity, totaling 690 hours for all four users. This is a good think meaning there is 1:1 between hours capacity per user showing in the resource management board, but this is not rolled up right to the group level

Adrianadrian_1-1751495053717.png

  •  

 

 

4 REPLIES 4

Mark Manders
Mega Patron

Does the group have a manager that is not part of the group itself? I am just guessing, because I didn't notice it myself. 

To be sure it it's a bug or not: log a Case with NowSupport and let them tell you where the difference is coming from.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Adrianadrian
Tera Contributor

Hi @Mark Manders  Thank you for reaching out. The group manager is not a part of the group, the first row is the group (grouped by primary group). Below is a picture with screenshots. The first row you see

Here you see each user has 172,5hours capacity. In sum that would be 690 hours.

However when checking capacity for the group by clicking into the cell for group for July:

Adrianadrian_0-1751560780152.png

 

See when clicking into the group. Capacity is stated to be 660 hours. 

Adrianadrian_1-1751560850647.png

There is 30 hours missing, which leads me to believe this might be a bug/issue, where capacity for the group is fetched from another source, or calculcating wrong through a script

 



Arnab19
ServiceNow Employee
ServiceNow Employee

@Adrianadrian  if you are still facing the issue, please raise a case with SN support and we will look into it.

Hi. It is raised to ServiceNow now