dbTalk Databases Forums  

How to set FTP to Ignore Calculations Unless *ALL* Fields Complete

comp.databases.filemaker comp.databases.filemaker


Discuss How to set FTP to Ignore Calculations Unless *ALL* Fields Complete in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
awfulgrace
 
Posts: n/a

Default 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?


Reply With Quote
  #2  
Old   
FP
 
Posts: n/a

Default Re: How to set FTP to Ignore Calculations Unless *ALL* Fields Complete - 10-07-2005 , 10:07 PM






I assume your fields "Client Review Time" and "Revision Processing
Time" are calculation fields.
I imagine the calc is something like
PDF Out Date - Date Comments Entered

Change your calc to something like;
Case(
isempty(PDF Out Date), "",
isempty(Date Comments Entered), "",
PDF Out Date - Date Comments Entered)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.