5 Replies Latest reply: Sep 14, 2017 3:11 AM by Agrim Sharma RSS

    Conditional Categorization.

    Agrim Sharma

      Hi All,

       

      Attached is my data file, and following are conditions that i want to apply on data,

       

      please correct if i am wrong with my made conditions, my formulas are-


      eg.

              if(Actual_Finish='NA', if( Actual_Start='NA',if( "% Complete"='100%' , '2' , '3')))

              if(month(Baseline_Start)=month(Today()), if( Project_Manager=' ',if(Project_Manager= '?',if( "% Complete"='0%' , '2' , '3'))))

       

      for Name "%_Completion"= '100%'

      if "%_Completion" =100%  and   "Actual_Start" or "Actual_Finish" is null or 'NA'---category "2"

      else---category"3"

      for Name "%_Completion"= '0%'

      if "%_Completion" ="0%"  and   "Project_Manager" or "Baseline_Start" is null or 'NA' or '?'---category "2"

      if "%_Completion" ="0%" and "Baseline_Start" month< Current_Month---category"1"

      if "%_Completion" ="0%" and "Baseline_Start" month>= Current_Month---category"3"

      for Name "%_Completion"= '1%-99%'

      if "%_Completion" ="1%-99%"  and   "Actual_Start" or "Project_Manager" is null or 'NA' or '?' ---category "2"

      if "%_Completion" ="1%-99%"  and   "Finish_Date" < "Current_Month"---category "1"

      if "%_Completion" ="1%-99%"  and   "Finish_Date" >= "Current_Month"---category "3"

      if "%_Completion" ="1%-99%"  and   "Actual_Start" > "Current_Month"---category "2"