since calculated field returns incorrect grand total (excel bug) need help with formula to add to my table

[pcorpz]

Hi experts! I have a monthly pivot table that has calculated fields. My table contains tickets of engineers. One calculated field is to show the difference in hours -- this is my formula hours - 172 (this is our average monthly hrs for engineers). what would be my formula in my table, if it's by ticket that the engineers worked on?

 

[ravi2628]

Hi experts! I have a monthly pivot table that has calculated fields. My table contains tickets of engineers. One calculated field is to show the difference in hours -- this is my formula hours - 172 (this is our average monthly hrs for engineers). what would be my formula in my table, if it's by ticket that the engineers worked on?

Hi

is the example you are looking at

Name	Total Tickets	Total Avg Hours in a month	Per Ticket
Engineer1	300​	172:00:00​	00:34:24​

if it is wrong can you share the sample so that exact logic can be shared

 

[pcorpz]

Hi

is the example you are looking at

Name	Total Tickets	Total Avg Hours in a month	Per Ticket
Engineer1	300​	172:00:00​	00:34:24​

if it is wrong can you share the sample so that exact logic can be shared

Hi Ravi, my table looks like this:

Ticket Date	Billing Code	Ticket/Task Number	Resource	Hrs
7/6/2021​	Remote Support	T20210706.0008	Doe, John	0.25​
7/12/2021​	x1 non-routine work condition (Emergency/Overtime/After-Hrs/KIS Holiday)	T20210712.0051	Doe, John	0.25​
7/16/2021​	Remote Support	T20210716.0002	Doe, John	1​
7/23/2021​	Remote Support	T20210716.0002	Doe, John	0.5​
7/16/2021​	Remote Support	T20210716.0006	Doe, John	1​
7/16/2021​	Remote Support	T20210716.0004	Doe, John	0.75​