{@Number To Average}

If (condition) then {table.field} else 0

 

{@Count where Condition is met}

If (condition) then 1 else 0

 

{@Average where Condition is Met}

if sum({@Count where Condition is met}, {group field}) > 0 then

  sum({@Number To Average}, {group field})/ Sum({@Count where Condition is met}, {group field})

else

0

 

You'll only put the last formula on your report - it's the average you're looking for.  If you're using it as a grand total and not a group total, take out ", {group field}" from the sums.

 

This process gets the numbers from just the records that match your condition (first formula) and provides a means of counting just the records that match your condition (second formula).  You can then use those numbers to calculate the average (third formula).

 

-Dell

 

-Dell