Selection criteria off of a formula 1

[LLowrance]

Crystal 8.5, SQL Database

I've been asked to produce a report which will display records where a summary field called SUM(Lost_Time_Days) are + or - 10% of a number called MID_LOD. MID_LOD is also a formula I created because that number is not captured. We do capture HIGH_LOD and LOW_LOD. (LOD is Length of Disability and Lost_Time is the number of days a claimant is losing time from work)

How can I get Crystal to only include those records where the sum(lost_time_days) is within the range of plus or minus 10% of MID_LOD? I've created formulas to see what the number would be plus or minus but they are not available when trying to use the "between" function. Basically I need crystal to recognize:

Sum(Lost_Time_days)between +/- 10% of MID_LOD.

Thanks

Lowell

 

[lbass]

I'm guessing you want to select employees who meet this criterion. If this is so, group on {table.employee} and then go to report->edit selection formula->GROUP and enter:

sum({table.losttimedays},{table.employee}) in .9*{@Midlod} to 1.1*{@Midlod}

-LB