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.
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.