How to filter out the unspecified items from a report? | Community
Skip to main content
cathyw49544988
cathyw49544988
Level 5
October 10, 2017

How to filter out the unspecified items from a report?

  • October 10, 2017
  • 3 replies
  • 7658 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.

    3 replies

    Hyder_Ziaee
    Adobe Employee
    Hyder_ZiaeeAdobe Employee
    Adobe 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)?

    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
    Adobe Employee
    Hyder_ZiaeeAdobe Employee
    Adobe Employee
    October 11, 2017

    It should work:

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

    S
    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.

      Terms & ConditionsAccessibility statement

      Loading footer...