AnsweredAssumed Answered

Need help with calculation field

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


Need help with calculation field


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.