Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Reporting on total planned hours per demand

Coen Eskens
Tera Contributor

Hi everyone!

 

Is there a (otb) way to report on the total planned hours per demand? The total planned cost is calculated based on the hours + rates of the resource plans, but we would additionally like to report on the sum of planned hours in the resource plans for each demand to have a better overview of the heaviest demands. Does anyone know if there is a easy way to view this without adding a custom field to the demand table?

 

Many thanks for any tips!  

1 ACCEPTED SOLUTION

Tai Vu
Kilo Patron
Kilo Patron

Hi @Coen Eskens 

Within the list report, you can leverage the List Calculation to achieve it.

Sample below.

TaiVu_0-1699284742153.png

 

In the other hand, you can use Aggregation SUM to have the total value.

Screenshot 2023-11-06 at 22.33.51.png

 

 

Cheers,

Tai Vu

 

 

 

View solution in original post

1 REPLY 1

Tai Vu
Kilo Patron
Kilo Patron

Hi @Coen Eskens 

Within the list report, you can leverage the List Calculation to achieve it.

Sample below.

TaiVu_0-1699284742153.png

 

In the other hand, you can use Aggregation SUM to have the total value.

Screenshot 2023-11-06 at 22.33.51.png

 

 

Cheers,

Tai Vu