C:\Users\Workspace\Downloads\Current Phase Calculation Example.xlsx|||`Sheet1$`
False
1
Current Phase Calculation Example.xlsx
Query=`Sheet1$`
Client
Status
V_WString
20
NULL
IF [Client]!=[Row+1:Client] and [RAG]="COMPLETE"
THEN "Y"
ELSEIF [Client]=[Row-1:Client] and
[Row-1:RAG]="COMPLETE" and [RAG]!="COMPLETE"
THEN "Y"
ELSEIF [Client]!=[Row-1:Client] and [RAG]!="COMPLETE" THEN "Y"
ELSE Null() ENDIF
IF [Client]!=[Row+1:Client] and [RAG]="COMPLETE"
THEN "Y"
E...
False
False
"Client","Stage","Date","RAG","Current Phase"
False
False
True
False
False
False
False
False
False
upper
C:\Users\WORKSP~1\AppData\Local\Temp\Engine_12500_f266553caeac43d2afb77abaec364d84_\Engine_7836_1b636e0b27254f00be4441c406604faf_.yxdb
Horizontal
Phase