AnsweredAssumed Answered

Help with Nested IF/Case/Let and a Multi Milestone evaluation

Question asked by thebridge on Feb 4, 2016
Latest reply on Feb 4, 2016 by thebridge

Greetings Everyone,

 

This project is FileMaker 11

 

 

I have a 14 day time period  and we know the start date

 

there are 8 milestones in between start date and end date(which is calculated)

 

as time passes, each milestone needs to be evaluated for On schedule or behind schedule

 

the result of each milestone evaluation does not need to permanently captured (although this may be a feature needed at a later time so I would love some ideas on this as well)

 

The result of the evaluation does need  to be displayed in the calculated Status field until the next milestone arrives and is evaluated for "On Schedule/Behind Schedule"

 

There are manually entered and calc date fields that the evaluations are test against:

 

Example,

Milestone 1 is On Schedule if the date of its completion is Equal or less than start_date +2, if greater than, it is Behind Schedule

 

Milestone 2 is On Schedule if the date of its completion is Equal or less than start_date +3, if greater than, it is Behind Schedule

 

and so on until the 14 days have been evaluated.

 

I have had no success using Nested IF statements which I thought were the only way to keep the calculation going after the first result tested true.

 

Ideas?

 

Thank you,

Robert

Outcomes