Skip to Content

Replace Blank/Empty value with NODATA

I tried the formula to remove blank/empty value from the table below.

But seem not working. Any advice to remove blank/empty value.

=[HISTORIC PRODUCT] Where ( [HISTORIC PRODUCT] <> " ")

I know it can be done with adding the report filter but I need through formula

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 01:04 PM

    Apply a Block level Filter Saying [HISTORIC PRODUCT] Is Not Null that should work for you

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 01:06 PM

    Please find attached screen shot

    In Place of Student Id use your Dimension


    Capture.JPG (12.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2016 at 01:06 PM

    You can also write the code as:


    =[HISTORIC PRODUCT] Where ( Not(isnull([HISTORIC PRODUCT])))

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2016 at 07:46 PM

    Can you pls explain why are you not applying the filter to exclude the null values?why specific you are looking from formula.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 07:59 PM

    Try

    =if isnull ([HISTORIC PRODUCT]) then 0 else [HISTORIC PRODUCT]

    then use filter: [HISTORIC PRODUCT] greater then 0

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 28, 2016 at 02:13 PM

    Use this:

    =If(Length([HISTORIC PRODUCT])>0;[HISTORIC PRODUCT];"NO DATA")

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Kuldeep Ghosh

      The problem is that RUC has said that he doesn't want to use a filter, which is the only way to exclude these things. One option is to use NoFilter in the total at the bottom of the block so that those that he's filtered still appear in the total, but then you'd need an explanatory note of what's missing.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.