How to exclude or hide values in a report

[trishita]

I do not want to show the values 0.00 in my report.I have already used the option suppress null value but still I am getting them.How can I hide them?

[timpoismans · Accepted solution]

Null values are different from 0.00000 values. Null values only appear when a field has no data for that record, so naturally, the 0.000 is a value.

That said, in case this is a measure, it could as well be that these aren't zero values, but it is a result with lots of zeros after the decimal.

You could always do an If-check in your script on [Fuel per last ...] for checking if the value is 0. If it is zero, give it the value Null(). This will allow you to use the Suppress null values.

Example:

If([Fuel per last ...] =0, Null(), [Fuel per last ...])

[trishita]

Currently I tried the following codes

If([Fuel per last Noon] =0.000, Null(), [Fuel per last Noon]) and related but I got this value.Now I want to hide this whole row..what should I do?

[gavinigovind452]

can you provide expressions for more information

[pooja_prabhu_n]

Hi,

Check suppress null value for [Fuel per last Noon] dimension .

Thanks,

Pooja

[trishita]

timpoismans‌ I rearranged the dimensions and it is working fine.Thanks for your help

[timpoismans]

You should be able to hide null values per expression in your table. If you hide them for each expression, the row with null values for each expression shouldn't show in the table.

[timpoismans]

You're welcome!

[trishita]

Hi Govind,

Thanks for the enquiry but the question is closed and answered.

Regards,

Trishita