4 Replies Latest reply on Jul 22, 2019 7:55 AM by Paul Wachtler

    How to show a KPI in percentage?

    Abhijit Nikhade

      I need to convert the KPIs Immediate Action, Next Opportunity and Overdue Repairs (shown in the picture below) into the percentage of open cases.

      I would like to show these percentage KPIs instead of the numbers I am showing on dashboard "Dash-KPI-All". I have attached the sample workbook here. I have created the calculated field "percentage_of_immediate_action_cases_CMS" with all the conditions. But looks like its throwing NULL value and not displaying it properly. I tried do display the same on sheet "Test_Page" as most of my KPIs are being calculated as a separate sheet.  How to achieve this? Also, I want to show the percentage symbol in KPIs as well.

       

       

       

      Appreciate the help from community.

       

      Best,

       

      Abhijit