Calculation field question
My question is: I have a calc field set up to calculate days delayed from the target due date. I need the calculation to stop calculating if there is a date in the completed field. How do I do this? I have tried some things but they don't work.
My calc so far is set up like this and it works except for it doesn't stop calculating days delayed:
Days delayed field calc = If(GetAsNumber(Target Date) > 0 and GetAsNumber(Target Date) <= GetAsNumber(Get(CurrentDate));GetAsNumber(Get(CurrentDate))-Target Date; "")
I am using FileMaker Pro 10 on a Mac. The database is located on FileMaker Server.