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

    Need help with calculation field

    bate01

      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.