Trouble with a calculation field
I am a fairly new user so please bear with me.
I am working in FileMaker Pro 10 on a Mac using OS X
I am having problems getting a calculation to work.
I have a field called Days delayed (number) that is a calc field, the fields it is to calc are Target date (date field) and Completion date (date field).
What I need it to do is calc based on if there is a value in the Completion date field then it is to subtract from the Target Date field to get days delayed. If the Completion date field is empty then Target Date is to subtract from the Current Date to get days delayed. If it is not delayed then the result should be 0.
I almost hasd it working but it was giving me a negative if the completion date - target date wasn't delayed so I went to adjust the calc and broke it.
Thank you very much for your assistance.