Complex Formula converted to Crystal

[shelby55]

Hi

I am using Crystal 9.0 reporting from an Access 2003 database.

I want to be able to graph a value, upper and lower confidence levels (at 95%). The formulae used in Excel:

UCL

=C2/D2*(1-1/(9*C2)-1.96/(3*SQRT(C2)))^3*100

LCL

=(C2+1)/D2*(1-(1/(9*(C2+1)))+1.96/(3*SQRT(C2+1)))^3*100

C2=sum(observed incidences)
D2=sum(expected incidences)

Usually this would be graphed as "box and whisker" but that isn't an option in Crystal so is there a workaround? Thanks.

 

[Madawc]

I don't know Access 2003 or "box and whisker" , but since no one else has answered, I'll try.

Crystal is a reporting tool, not a full language, so it limits what you can do. Your formulas might run into problems with trying to do a summary of a summary.

You have not however shown what you've been able to convert and what is different. Maybe start a new threat giving a more specific question.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP