3 Replies Latest reply on Jul 31, 2018 7:23 AM by Zhouyi Zhang

    Exclude Nulls from attribute

    Sandra Ragues

      Dear all,

       

      I would like to exclude the nulls from a function I have built:

      1 - I have created a formula to get only the names of the people who attended in 2018 --- IIF([Year of Event]=2018,[Delegate name],"NULL")

      2. This gave me all delegates who attended in 2018 however, when I want to do --- Count (delegates 2018) it will also count the null. How can I exclude the null from the count?

      I want to do it as a formula because I want to display the result in a graph that contains other metrics/attributes where the null cannot be excluded.

       

      Let me know if you know the solution

      Thank you

       

       

      Sandra