2 Replies Latest reply on Sep 30, 2009 2:22 PM by imgaryshap

    Averaging with empty fields

    imgaryshap

      Title

      Averaging with empty fields

      Post

      I'm using FMP 8 on a mac and i'm an above average novice (at this point, because of all the help and education this forum has already given me!).

       

      In my records i have key date fields.  I then use these date fields to calculate amount of time.

       

      I know how to aveage the individual time fields.

       

      So for example - If I have West Coast Duration and East Coast Duration fields, I know how to run a summary that gives me the average time a project sits on either coast. ("West Coast Average Time:  3 weeks") 

       

      Here's my question - how can I make an Average Summary omit empty fields?

       

      For example - sometimes a record does not have an East Coast time.  It's not "0" - it's simply blank.  But when I run the summary - that record is still included in the average.   

       

      I'm assuming I need a calculation that disregards empty fields, without completely omiting the record via a script?

       

      thanks.

       

      -G.