Expand my Community achievements bar.

SOLVED

Need help with calculated field and pulling it to an Hours report Matrix grouping

Avatar

Level 4

I'm developing an Hours report and need some help creating a calculated field and then would like to pull it into the Matrix grouping.

The field should calculate the percentage of Internal hours out of the total hours for the given time frame.
I would like to configure the calculated field in the Matrix grouping so the field calculates the correct percentage of Internal hours out of the total hours.

jamesmillerzjd_0-1671036407859.png

 

Any help is appreciated!

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

James, I'm not sure if I fully understand your ask, but when you create a calculated field in the system, the value will be based on the object total. You cannot specify a time frame for a calculated field - by default, it will pull in all-time. 

If you did want to go the route of choosing a specific time frame and calculating the percent of internal hours based on the total hours given for that time frame, it would have to be done through text mode. 

Hope that helps to clarify things. Let me know if you have any questions! 

View solution in original post

3 Replies

Avatar

Correct answer by
Employee Advisor

James, I'm not sure if I fully understand your ask, but when you create a calculated field in the system, the value will be based on the object total. You cannot specify a time frame for a calculated field - by default, it will pull in all-time. 

If you did want to go the route of choosing a specific time frame and calculating the percent of internal hours based on the total hours given for that time frame, it would have to be done through text mode. 

Hope that helps to clarify things. Let me know if you have any questions!