Suppressing null values-expression

[#1]

Hi

I have a straight table.

Dimension: Product code

Expressions:

Sum(Free stock)

Sum(Month 24)

Sum(Month 25)

Sum(Total Value 24 + 25)

If Month 24 column has a value greater than 0 then I'd like it to appear in the table. If the value = 0 then I would not like the row to appear (even if there's data in the other expressions).

I know there is "suppress null values" within a dimension, but is there the option for an expression?

Please can you help?

thanks

[khalander]

In Presentation Tab you can check suppress Zero values

[#3]

Hi Gemma,

With selecting "conditional" for this expression (in the expression tab), and applying ...>0 or not(isnull(...), this column will disappear as you want.

[avinashelite]

Go to Chart Properties >Presentation > Suppress Zero values

[#5]

Thanks, but this does not remove the zero values from the expressions. It's checked and I still have 0's.

[#6]

Thanks, but this does not remove the zero values from the expressions. It's checked and I still have 0's.

[#7]

thanks, but I do not require the column to disappear, I'd like the rows to disappear if they are populated with a 0 value within this column

[MarcoWedel · Accepted solution]

Hi,

maybe like this:

Dimension: Product code

Expressions:

If(Sum(Month 24), Sum(Free stock))

Sum(Month 24)

If(Sum(Month 24), Sum(Month 25))

If(Sum(Month 24), Sum(Total Value 24 + 25))

(+suppress zero values)

hope this helps

regards

Marco

[#9]

Thank you, that's worked.

[MarcoWedel]

You're welcome

Nice to hear it worked for you.

regards

Marco