Percentages 1

[Garridon]

I'm working on a report that will do some calculations. The report will basically tell the user what percentage of deadlines that a department has missed. I'm using two fields, one is dateDue and the other is dateCompleted. If the dateCompleted falls after the dateDue, then it's a missed deadline. How do I get the percentage of missed deadlines? I've been trying to do it with expressions, but I haven't had much luck yet.

Thanks!

Linda Adams (Garridon@aol.com)
"The Importance of Being Grammarian," published in The Toastmaster, March 2001

http://www.geocities.com/hallona_2000

http://www.david-hedison.com

 

[seaport]

I think this is actually a maths question rather than a report design question.

I suggest to get the dateStart data first. Then you can get how long the department planned to spend on a task (DaysPlanned), and how long the department missed the deadline(DaysMissed). Finally, you divide the DaysMissed by the DaysPlanned to get the percentage.

Hope this will help.

Seaport

 

[Garridon]

Thanks! You helped me to get it to work (plus, once I figured out that I had to change the Format property to Percentage as well).

Linda Adams (Garridon@aol.com)
"The Importance of Being Grammarian," published in The Toastmaster, March 2001

http://www.geocities.com/hallona_2000

http://www.david-hedison.com