1 Reply Latest reply on Oct 8, 2018 10:08 AM by Michael Ye

    Calculation Issue when trying to fix data

    Debayan Bhattacharjya

      Hi,

       

      I have a requirement where i have 4 fields .

       

           

      ProjectSubProjectRoundStatus
      P1S11Not Completed
      P1S22Completed
      P1S33Completed
      P2S41Completed
      P3S51Not Completed
      P3S62Not Completed
      P3S73Completed
      P4S81Completed
      P4S92Not Completed

       

      Now in the above the records are sorted based on Round, for individual project.

       

      Now for every Project field, if there is status as COMPLETED more than once Then i need to show those project details Data.For example above case for Project P1,P4 there are Accepted Status More than once.

      So Output which i need is below only showing Project P1 and P4

       

      ProjectSubProjectRoundStatus
      P1S11Not Completed
      P1S22Completed
      P1S33Completed
      P4S81Completed
      P4S92Not Completed

       

       

      Kindly Help me on this.

       

      I was trying to use Table Calculation, However i am unable to use it for Table Calc Lookup function , as we cant use Table Calculation inside LOD and i need to show the entire Project details of these data set and need to Fixed it