任务工期预警
IIf([基线工期] = 0 And [工期差异] / 480 <= 0, "无基线", IIf([工期差异] / [基线工期] <= 0.05, "正常", IIf([工期差异] / [基线工期] >= 0.2, "严重延迟", "延迟")))
Task Duration Alert
IIf([Baseline Finish] = 0 And [Duration Variance] / 480 <= 0, "N/A", IIf([Duration Variance] / [cBaseline Finish] <= 0.05, "Normal", IIf([Duration Variance] / [Baseline Finish] >= 0.2, "Serious Postpone", "Postpone")))
-----------
任务进度预警
IIf([状态] = 0, "已完成", IIf([状态] = 1, "正常", IIf([状态] = 2, "延迟", "任务还未开始")))
Task Finish Alert
IIf([Start] = 0, "Finished", IIf([Start] = 1, "Normal", IIf([Start] = 2, "Delay", "Not Finish")))
-----------
项目工期预警
IIf(ProjDateValue([基线完成时间]) = 4294967295, "无基准