how to 'UNSUPRESS' null or zero values

[Anonymous]

I have a straight table with 1 dimension and multiple expressions. when the year filter is not selected, rows with null or 0 values are still on display. but when I select on a year or month, rows with null or 0 values go away. I need the rows to stay regardless of null or not.

How do i do that. Thanks

[sasikanth]

May be there are no null values in selected Year/Month ,

un check suppress missing and supress zero values

Please share your sample file

[Chanty4u]

chk dis may helpful.

[jagan]

HI,

Try like this

=Sum(Sales) + Sum({<Year-={'*'}>})

Hope this helps you.

Regards,

Jagan.

[Anonymous]

may be this?

Properties -> Dimension -> Select any Used Dimesnion(From Top Right) -> Tick Show All values & Untick Suppress Null Values(Right Middle)

[HirisH_V7]

Hi,

Try this,

Sum({1-<Year={"*"}>}Sales)+Sum(Sales)

HTH,

Hirish

[Anonymous]

Try this expression it is working  =if(Sum(Sales)='0',0,sum(Sales))

[renuka_sasikumar]

Can you share the sample file.

Regards,

Renuka S

[sangeethag]

Hi

If you have zero or null in your data itself, below will work for you.

Properties -> Dimension -> Select any Used Dimension(From Top Right) -> Tick Show All values & Uncheck Suppress Null Values(Right Middle)

Otherwise you have to create dummy data in your table to show null and zero items in the report.