6 Replies Latest reply on May 27, 2010 2:04 PM by mrvodka

    Need help with calculation field



      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.