cancel
Showing results for 
Search instead for 
Did you mean: 

Rows with empty/zero measures

Former Member
0 Kudos

I have a webi report(This is a deski to Webi converted report through RCTool).There are some rows in Deski where there are zero values for measures.Once the report got converted to Webi the rows with 0 measures are not showing up in webi.Once I apply a filter on any of the dimensions then I can be able to see these rows.Is there any way how I can display these rows with 0 measures?I have already checked the option in webi "Show rows with empty measures" and "Show rows with empty dimensions"

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Plz check with the following condition.......

If ( Isnull ( [measure] ) ) then 0 else ([ measure ]).

Regards,

ArunKG

Edited by: ArunKG on Oct 19, 2011 4:40 PM

Edited by: ArunKG on Oct 19, 2011 4:40 PM

Former Member
0 Kudos

Hi Arun,

Thanks a lot for your help.

However I have resolved it by checking the option "Apply implicit sorts" from break properties.

Answers (0)