Select Statement on Field

[cjkeefer]

Just a quick Question,

I am tryin to perform a select statement (is between) on a field tilted "Weekending" so that my grouped results of a file titled "efficency" will be between the designated time frame. ie 4/10/03 & 4/11/04.

My Problem.

I am trying to perform this select statement on the "weekending" field for "efficiency" twice.

example of the results I want for graphing purposes.

Efficency = 100 between 3/2/03 & 4/2/03

Efficency = 95 Between 5/2/02 & 4/2/03

This will enable me to plot a graph showing both efficeincy fields with different weekending select statements.

If you know how I would appreciate the help.

Thanks,

 

[Ngolem]

You would have to specify one variable in the record select statement such as the date to collect all possible records...then in a Group select formula you could specify the Efficiency to 95 and 100 to further refine the data

Jim Broadbent

 

[lbass]

As Jim mentioned, to achieve something like your example results, you would need to select for the entire period under consideration:
{weekending} in Date(2002, 05, 02) to Date (2003, 04, 02)

Then for each of your sample time periods, create a formula:

if {weekending} in Date(2003, 03, 02) to Date(2003, 04, 02) then {efficiency} else 0

if {weekending} in Date(2002, 05, 02) to Date(2003, 04, 02) then {efficiency} else 0

I'm guessing that the "efficiency" result you are seeking is actually an average rate that you will have to calculate. Is the field {efficiency} a number that is then compared to another field? Or is it already a rate?
If you group on weekending, summarize the above formulas at the group level. If you are doing averages, you will need to exclude zeros from consideration.

If you only want the average rate for each time period (not for each weekending within each time period), you would need to use summaries of the formula fields at the report level.

-LB