PROBLEM WITH AVERAGES

[a_rosenbaum_(Guest)]

I HAVE A REPORT WHICH UTILIZES THE DAYS BETWEEN FUNCTION - SOME OF THE RECORDS DO NOT HAVE DATES IN THEM SO I USED THE FOLLOWING EXPRESSION __IIF(ISBLANK(SUB_DATE),0,IIF(ISBLANK(ISS_DATE),0,DAYSBTWN(ISS_DATE,SUB_DATE)))____THE PROBLEM IS WHEN I TRY TO DO AVERAGES ON A GROUP IN INCLUDES THOSE RECORDS WHERE THE NUMBER IS ZERO - ____IS THERE ANY WAY TO ELIMINATE THE RECORD FIELD SHOWING ZERO FROM THE AVERAGE CALCULATION.____

[kfleming]

Place the calc field on the layout, Uncheck the Show Zero box and then take it off the layout.__The average will then exclude the blank zero values.____Kathleen__R&R Support