formaula for percent on time 1

[Janny]

I am trying to figure out a formula for percent ontime assignments and late assignments and then for the everyone who is greater than 85 percent ontime set the background to green. I have totals for ontime and late but cant seem to get the formula right. I am using crystal version 8

 

[lbass]

if your formula for {@ontime} is something like:

if {table.submissiondate} <= {table.duedate} then 1 else 0

Then you could use the following for {@percentontime}:

sum({@ontime},{table.student}) % count({@ontime},{table.student})

You would do similar formulas for {@late}.

Then you could go to the section expert->group header or footer (wherever you have the summaries)->color tab->background->x+2 and enter:

if {@percentontime} > 85 then crGreen else crNoColor

-LB