Need help creating Sharepoint KPI

Posted on 2010-08-16
Last Modified: 2012-05-10
I would like to create a KPI that would check if the values in column A are empty and show the following:

Green light -> 100% of items in the list have value in column A
Yellow light ->50-100% of items in the list have value in column A
Red light ->0-50% of items in the list have value in column A

I was playing around with it but keep getting the "The specified value calculation is not valid. Specify a valid value calculation" error message.

I use MOSS 2007.

Question by:MisUszatek
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3

Expert Comment

ID: 33450289
Can you post the calculation?

Author Comment

ID: 33450300
Under "Value Calculation: " I selected  "Percentage of list items in the view where". Then I tried to choose the column name, then "is equal to" and leave empty the value field.

Accepted Solution

SharePointGirl earned 250 total points
ID: 33450363
I would create a calculated column which has a value of 1 if the field is not null


and then use this field in your value calculation
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 33450438
I got the error first but it was just missing the bracket. How can I modify this calculation to check for the value in two columns with OR ?

Expert Comment

ID: 33450453
No just use the calculated field and use percentage where value is less than 1

Author Comment

ID: 33450464
Let me rephrase it: how to change your formula to check if a value in Column A OR B is blank. Then I will do the KPI based on that.

Expert Comment

ID: 33450484
IF(NOT(ISBLANK([Column1])), IF(NOT(ISBLANK([Column2])),1,0),0)

Sorry I have not got SharePoint up and running to check.


Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sharepoint workflow on list 7 51
InfoPath Business days 1 72
Sharepoint KB 2 87
Sharepoint User Name Displaying incorrectly. 17 83
Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question