PROBLEM WITH AVERAGES
Posted: Fri Jan 25, 2002 5:22 pm
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.____