2 Replies Latest reply on Nov 18, 2018 10:10 PM by lalitha p

    Not to add but show independently based on project code and project name

    lalitha p

      I have 2 excel files - one with dates of when i receive the value at project level and the other excel is the exact value for each project. something like this.

       

      1st one:

      ProjectCode  Proj Name    Client      Due Date1         Due Date2    Due Date3

        123                    XX           ABC        03-Jul-'18         03-Oct-'18       03-Jan-'19

        456                    YY           BCD        21-Mar-'18       06-Mar-'19      03-Mar-'20

        457                    ZZ1         CDA        13-Oct-18             NA                    NA

        457                    ZZ2         CDA              NA               14-Nov-18           NA

       

      2nd Excel::

      Proj Code          Proj Name           Client     Score            Date

         123                      XX                    ABC        1.2           03-Jul-18

         457                      ZZ1                  CDA         3.9          13-Oct-18

         457                      ZZ2                  CDA         4.2          14-Nov-18

         123                      XX                    ABC        3.2           03-Oct-18

       

      What i have to do here is:

      I have to list out all the projects with their dates and then to show the score if any project receives, if it didn't receive on time then i have mark it as red/amber something like that..

       

      Output i am looking for :  only for 2018 we show

       

      Client          Project      Proj name           Jan         Feb   Mar     Apr    ...    Jul       Oct    Nov   Dec   

         ABC           123             XX                                                                       1.2      3.2

         CDA           457            ZZ1                                                                                 3.9

         CDA           457            ZZ2                                                                                            4.2

         BCD           456             YY                                          Due        

       

      This is how i am expecting results, but if a project is having only due date then it is working good otherwise i have 2 cases here where i am facing issues.

       

      Client          Project      Proj name           Jan         Feb   Mar     Apr    ...    Jul       Oct    Nov   Dec   

         ABC           123             XX                                                                       4.4       4.4

         CDA           457            ZZ1                                                                                  5.1

         CDA           457            ZZ2                                                                                            5.1

         BCD           456             YY                                          Due       

       

      I am actually getting like this. My worry here is

       

      It is adding two values and then showing up in the data. But how do i have consider to get how i wanted..

       

      Regards

      LP