How to filter out the unspecified items from a report? | Community
Skip to main content
cathyw49544988
cathyw49544988
Level 5
Oct 10, 2017 5:16 PM UTC

How to filter out the unspecified items from a report?

I tried "does not contain" "Unspecified". But it won't work. I believe it is null value. So what should I use?

Thanks,

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    12 replies

    alv123456
    Level 5
    Oct 12, 2017 2:05 PM UTC

    Sometimes "None" works

    Translate
    cathyw49544988
    cathyw49544988Author
    Level 5
    Oct 12, 2017 2:38 PM UTC

    Thanks. It worked. Then I noticed one thing. It filtered out the null values. But the % value didn't re-calculate. Is there a way to show the re-calculated %?

    Translate
    Saurabh_Kumar1
    Level 5
    Oct 13, 2017 7:56 AM UTC

    Hello  - Filtering won't re-calculate, you have to use segment for re-calculation to apply.

    Regards,

    Saurabh Kumar.

    Translate
      Issao_Shoji
      Issao_Shoji
      Level 2
      Oct 11, 2017 1:11 PM UTC

      Hello

      Depending on your data, is you're trying to see just number, you would try 'filter'>'Advanced Options'; 'if any criteria are meet', 'contains one of': 0,  'contains one of': 1... until 9.

      Or you would try it in workspace, there you can filter does not contain > none.

      Regards,

      Mauricio Shoji

      Translate
      cathyw49544988
      cathyw49544988Author
      Level 5
      Oct 11, 2017 1:20 PM UTC

      If it is a text field, then what I should do?

      Thanks,

      -Cathy

      Translate
      Hyder_Ziaee
      Hyder_Ziaee
      Employee
      Oct 11, 2017 1:54 PM UTC

      It should work:

      Translate
      Hyder_Ziaee
      Hyder_Ziaee
      Employee
      Oct 11, 2017 5:19 AM UTC

      Try 'exists'.

      If this doesn't work, can you give more information about the report(variable) you are running and the tool you are using(RnA/Workspace/Report builder)?

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...