Experts Exchange connects you with the people and services you need so you can get back to work.

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?

shockacon

Asked: 2008-10-10

Advertise Here

Crystal Reports

1 Solution

LVL 101

mlmccCommented: 2008-10-10

Try it with the group specified

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

mlmcc

shockaconAuthor Commented: 2008-10-10

Once again you come thru.. there's a reason your #1 in the category! :) thanks again.

LVL 101

mlmccCommented: 2008-10-10

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

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.

formula percentage calculation

Join & Write a Comment Already a member? Login.

Featured Post