2 Replies Latest reply on Mar 6, 2013 9:44 AM by Sarah Gehrke

    Calculating counts using nested IF statements

    Sarah Gehrke

      I am trying to do counts based on multiple conditions based on work step. So my column is work step and I would want to do something like count the number of stores which are 100% complete with workstep 1, but are 0% Complete with workstep 2. The worksteps are not always this well ordered so I don't think a table calculation will work in my larger data set.

       

      StoreWorkstep% Complete
      11100%
      12100%
      21100%
      22
      0%
      31100%
      320%