Webi report for missing values

[jacobsson_axel]

Hello, as it from time to time happens that you lose important data for whatever reason,  i´ve got the request to make a report that has a specific list of fields, columns, and only show the rows where one (or more) out of Three specific columns are missing a value and is empty.

I am now curious  how you would go about making such a report?

First thought was having a Control field for the three dimensions, saying that if value=null -> 0 else 1. Then show only rows = 0.

Thank you.

regards,

//A

[jacobsson_axel]

I found a way of doing this by using WebI:s simple filters; setting the "Control fields", each to = null.

I really need confirmation that this method really works as there really is no way for me to see if this is correct.

Will it work togehter when I now have 4 columns set to show only if empty row, for each column? Or will some of the rows not show?

regards, Axel