Each line of the report requires its own set of calculations for the time periods that are being evaluated. There are two elements (both columns) which control these calculations: Filter and Result.

Within a time period, a number of records will be partially or completely scheduled and delays will also be scheduled for each of the resources in the scenario. In the report writer, the Result controls what values are accumulated for each of these records or delays in the time period. The Result may contain main database data fields, calendar database data fields, fixed numbers, special report writer functions or any combination of these written as an equation.

The Filter column is optional and can be used to exclude some of the records or delays from the Result accumulation. The filter in the column may be based on main database data field values, specified resources, certain types of steps, the main database structure or any combination of these written as a logical statement or test. Only the records and delays which pass the test in the Filter column are accumulated. If the field in the Filter column is empty, then all records and delays in the time period are included in the evaluation.

Note that when the report writer calculates period values, it uses the field types for the data fields in the Result expression. The field type that can be assigned for the report field is only used for accumulating the period values into a total.