I created a formula field (number format) where the formula is "If (
{@DateDiff} <= Average (
{@Elapsed Hrs})) then 1 Else 0" where the datediff is the calculation for each individual work order's completion time and the average elapsed hrs is the average of the elapsed time over all the work orders in the report. When I place the new field into the report, 1's and 0's appear, but even though the field is in the report and is numeric, it doesn't show in the Insert Summary list of fields. I cannot figure that out...
rn