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.