Hi
Im trying to figure out a percent utilization of time report which Im about 90% complete on but I cant seem to get the last % calculation to work properly
Heres the scenario:
I have a formula that calculated the number of workdays in the date range the report brings back.
In each of those days im utilizing 5 min time slots so I multiply the number of work days formula by 288 in a formula called total slot count.
My next formula is the utilized slot count is just a subtraction of start slot time from stop slot time.
So next I want to calculate a percentage of the total slot count by utilized slot count so I can calculate the percent of time used vs. time slotted .. I cant get this to work in another formula called percent utilization which Ive tried (sum ({@Utilized Slot Count}))/{@Total Slot Count}* 100.
These are currently sitting in a group header for person lastname to get a sum of all days that are returned
sum ({@Utilized Slot Count},{GroupField}))/{@To
mlmcc