2 Replies Latest reply: Jul 5, 2012 8:10 PM by Patrick De Waegenaere RSS

    Sum of Plan finished

      Dear all,
      I have the following structure:
      PlanPlaceActivity# CardsFlag_Act Finished
      L1DFA110001
      L1DFA115001
      L1DFA111001
      L2DFA110010
      L2DFA210021
      L2DFA215261
      L2DFA214521
      L2CDA318951
      L3CDA324110
      L3CDA326330
      L3CDA411021
      L4CDA411031
      L4CDA412041
      L4CDA412251
      L4CDA413651
      I would like to know how much Plan are done, considering that all the Flag in the column Flag_Act Finished must be 1. If one activity is 0, the plan is unfinished. In this case, total of plan finished = 2, (L1 and L4)
      The same thing, I would like to know how many plan are done per places, considering the same rules.
      Must be a simple thing to do, but cannot figure out.
      Thanks in advance for any help, idea submited.
      Patrick