AnsweredAssumed Answered

Need help with calculation field

Question asked by bate01 on May 26, 2010
Latest reply on May 27, 2010 by mrvodka

Title

Need help with calculation field

Post

I am working with FileMaker Pro 10  (Mac OS X 10.5.8). I am a fairly new user to this so I am stuck. I know what I want the field to do but can figure  completely.

 

I have a calculation field that I need to give me a number result based on below:

Field name = Days delayed and Target date

 

If field % Complete is = 100 then field Days delayed = 0

If field % Complete is less than 100 then Target Date (based on a date entered) - current date = Days delayed

 

 

Thank you for your assistance.

 

Outcomes