
1. Re: Calculation of Utilization percentage over a period; monthly percentage is ok but overall is incorrect
Jeevan Krishna Jun 17, 2018 10:10 AM (in response to Rishu Mankotia)Hi Rishu,
1 basic issue that I see in this calculation is a usual mistake a lot of people does while doing division. Dont use sum(num/den) instead use sum(numerator)/sum(denominator) or aggregate(num)/aggregate(den). aggregate any aggregation
If your issue is that you are looking at a value higher than 100% utilization rate, the above solution handles that.

2. Re: Calculation of Utilization percentage over a period; monthly percentage is ok but overall is incorrect
Rishu Mankotia Jun 18, 2018 8:09 AM (in response to Rishu Mankotia)Hi Jeevan,
Thank you but that didn't work. I basically need to create a formula that aggregates the billing time and computes the percentage for daily weekly monthly and yearly levels. The calculation is required to sum the billing time and divide it by the total hours for a given period (number of working days*resource count*daily hours).
I have achieved to put monthly and yearly formula, but the day and week level aggregation is causing a problem. Is there a way to use a dynamic date calculation which will compute the utilization percentage based on the date range selected.