I have a calculation field that should count the time between a creation date and a close date. This calculation field shouldn

Hi LVA,

You will soon learn that quite often what we want to accomplish already exist, and most of the time, it is in a tip file somewhere.

Your are in luck because, Bob Weaver has donated a sample file to our forum showing how to do this.

Click Here to go to the thread and download. His is the first post.

HTH

Lee

Hi Lee,

Thanks.

I imported a spread sheet from excel with several calculated fields. The records appear as values. So far, so good! Now I am adding calculations to the filemaker fields but I want to leave the values in some of the records I imported but have the calculations performed on new records as I add them to the data base. Something like: case(method of payment="cash",0,method of payment="check",(keep record as imported or enter value manually if record is empty)...

MITCHELL said:

Something like: case(method of payment="cash",0,method of payment="check",(keep record as imported or enter value manually if record is empty)...

Do you mean you want to alter the calculation when the record is empty ?

BTW, why did you posted this querry on this thread ?

May be with another field n_manualentry and a calculation

Case(method of payment="cash",0,method of payment="check",Case(not IsEmpty(yourdata), yourdata, n_manualentry))