How to set FTP to Ignore Calculations Unless *ALL* Fields Complete -
10-07-2005
, 12:20 PM
I know how to set FileMaker Pro to ignore calculations if all fields
are empty, but I was wondering if there was a way to have the program
ingore calculations unless all fields are complete?
I'm trying to track timing on items that go through multiple rounds of
revisions. I've got fields for PDF out & Comments In for numerous
"rounds." The time between Out/In for the same round is captured as
"Client Review Time." The time between the "Comments In" of one round
and the "PDF Out" of the next round is captured as "Revision Processing
Time."
The problem is that once the item is approved, there is no date in the
PDF Out field for the next round, and the box for "Revision Processing
Time" for that round shows up as -52000, thereby scewing all averages I
have.
If there's no way to have FMP stop calculations unless all fields are
complete, is there possibily a way I can set it up for the averages to
ignore numbers that are so far scewed? |