• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2036
  • Last Modified:

formula percentage calculation

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

Any ideas?
0
shockacon
Asked:
shockacon
  • 2
1 Solution
 
mlmccCommented:
Try it with the group specified

sum ({@Utilized Slot Count},{GroupField}))/{@Total Slot Count}* 100

mlmcc
0
 
shockaconAuthor Commented:
Once again you come thru.. there's a reason your #1 in the category! :) thanks again.
0
 
mlmccCommented:
Next time you want to use a summary in groups.

Right click the field
Click INSERT --> SUMMARY
Setup the summary calculation
Choose the location
  Group footer

When you want to use it in a calculation it will be in the list of report fields in the formula editor

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now