script to filter the milestone stage

[Anonymous]

Hi all,

Please find the attached application and xldata in this we supose to built the logic for outputfield coloumn,

1.if 'P0 Exit' as actuals shows blank then 'P0 Exit'

2.if 'P0 Exit' as actuals shows date then it is 'P1 Exit'

3 .if 'P0 Exit' as actuals shows date then go for  'P1 Exit'  if  'P1 Exit' actulas shows date and 'P2 Exit' actuals as blanks then project is in 'P2 Exit'

Thanks

arun

[Anonymous]

Hi all,

Please suggest  how to crack this logic.

THANKS

ARUN