Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Filtering based on standard deviation
I'm trying to create an "outlier" filter for a Crystal Report. We have some values that are throwing off averages and want to filter them out. Using standard deviation to filter out the upper end of values seemed like a good solution. In my select formula I originally had the following...- jarmoore
- Thread
- Replies: 9
- Forum: Business Objects: Crystal Reports 1 Formulas
-
'This field name is not known' error
Here is a strange problem I have run into. My record select formula is as follows: {aw_illust.ORGID} in [55] and {aw_illust.AGENCY} = 'HCB' and {mod_illustrationDetails.CRTDATE} in #12/1/2009# to #12/31/2009# and ( InStr(UCase({@ClientName}), UCase("Smith")) > 0) and {aw_eCEntUsr.ENDDATE} =...- jarmoore
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 1 Formulas
