8 Replies Latest reply: Feb 5, 2018 7:29 AM by Sunny Talwar RSS

    How to Exclude Null Values from Calculation

    Jordan Hertl

      I am using the Simple KPI extension.


      My current syntax aims to count the Number of responses that score above 4 on a scale between 1 and 5. It also aims to only draw from the 4th quarter of 2017.


      It seems to be calculating correctly. It is just also calculating the #NULL values from the Excel spreadsheet. What is the best way to avoid this?


      Syntax below:


      Num(Count({<test_measure = {">=4"}>} {<[Admin_Qtr]={"Q4 2017"}>} test_measure) /Count(test_measure),'0%')