Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be there are no null values in selected Year/Month ,
un check suppress missing and supress zero values
Please share your sample file
chk dis may helpful.
HI,
Try like this
=Sum(Sales) + Sum({<Year-={'*'}>})
Hope this helps you.
Regards,
Jagan.
may be this?
Properties -> Dimension -> Select any Used Dimesnion(From Top Right) -> Tick Show All values & Untick Suppress Null Values(Right Middle)
Hi,
Try this,
Sum({1-<Year={"*"}>}Sales)+Sum(Sales)
HTH,
Hirish
Try this expression it is working =if(Sum(Sales)='0',0,sum(Sales))
Can you share the sample file.
Regards,
Renuka S
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.