11 Replies Latest reply on Mar 16, 2016 6:08 AM by Barb Reiser

    Grouped Values- Conditional Formatting

    Barb Reiser

      Hello,

       

      Can you tell me how to fix my calculation to work on the grouped values on sheet 2.

       

      I also tried changing it up to read "Didn't Meet & Needs Help" and deleting the extra row. The calc was valid but the formatting didn't work.

       

      IF ATTR([Pivot field values]) = "Didn't Meet" AND (COUNT([Pivot field values]) / TOTAL(COUNT([Pivot field values])) >= 0.20) then "Didn't Meet"

      ELSEIF ATTR([Pivot field values]) = "Needs Help" AND (COUNT([Pivot field values]) / TOTAL(COUNT([Pivot field values])) >= 0.20) then "Needs Help"

      ELSEIF ATTR([Pivot field values]) = "Exceeds" AND (COUNT([Pivot field values]) / TOTAL(COUNT([Pivot field values])) >= 0.50) then "Exceeds"

      ELSEIF ATTR([Pivot field values]) = "Meets" AND (COUNT([Pivot field values]) / TOTAL(COUNT([Pivot field values])) >= 0.50) then "Meets"

      ELSE "No Issue"

      END

       

       

      Thank you,

      Barb