SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i have a custom list in which i upload the data the incidents that have violated the targets I have added one more column in the list as Justification. The users are required to update the justifications for the violated incidents Based on this list I want to create the KPI list to know how many incidents are yet to update for the justifications How can I count the empty justifications in KPI list ?

share|improve this question
Have you tried creating a view, group by "Justifications" and display Totals by "Justifications"? – ChongYong Chin Mar 14 '13 at 7:32
Yep I did try but in totaling it only takes numeric / date time fields so Justification does not appear in the sum of <field list> – user15584 Mar 14 '13 at 9:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.