Skip to main content
cathyw49544988
cathyw49544988
Level 5
October 10, 2017

How to filter out the unspecified items from a report?

  • October 10, 2017
  • 12 replies
  • 7663 views

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
    October 12, 2017

    Sometimes "None" works

    cathyw49544988
    cathyw49544988Author
    Level 5
    October 12, 2017

    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 %?

    Saurabh_Kumar1
    Level 5
    October 13, 2017

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

    Regards,

    Saurabh Kumar.

      Issao_Shoji
      Issao_Shoji
      Level 2
      October 11, 2017

      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

      cathyw49544988
      cathyw49544988Author
      Level 5
      October 11, 2017

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

      Thanks,

      -Cathy

      Hyder_Ziaee
      Hyder_Ziaee
      Employee
      October 11, 2017

      It should work:

      Hyder_Ziaee
      Hyder_Ziaee
      Employee
      October 11, 2017

      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)?

      Terms & ConditionsAccessibility statement

      Loading footer...