?
Solved

formula percentage calculation

Posted on 2008-10-10
3
Medium Priority
?
2,036 Views
Last Modified: 2008-10-10
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
Comment
Question by:shockacon
  • 2
3 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 22688332
Try it with the group specified

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

mlmcc
0
 

Author Comment

by:shockacon
ID: 22688421
Once again you come thru.. there's a reason your #1 in the category! :) thanks again.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 22688479
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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question