Skip to Content
0

How to Remove blank cells based on Measure

Sep 14, 2017 at 08:53 PM

86

avatar image

Hi Webi Gurus,

We have AR Aging analysis report built in webi based on BEx query.

Our Aging brackets (measures) are 0-30, 31-60, 61-90, 91-120 and 120+

We are using structure based on BEx query which has invoices, Reason codes, Deductions etc.

If I run the webi report and drag in invoice or customer, there are so many blank rows and the report looks empty/blank and the user has to scroll down to see it plus it is really annoying to see so many pages with no data.

How can I get rid of blank cell/rows based on key figures if there is no data for aging, 0-30, 31-60, 61-90, 91-120 and 120+ brackets

Note that I am using structure from BEx along with these aging measures 0-30, 31-60, 61-90, 91-120 and 120+

Please advise if there is any feature in the tool or if I can write and logic.

Will really appreciate the help.

Thanks

10 |10000 characters needed characters left characters exceeded

can you share the data screenshot?

0

Thanks, it is resolved by changing the backend BEx structure.

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sven Oehme Sep 15, 2017 at 06:21 AM
0

Hi,

have you tried to use the table properties under format table?

Grtz

Sven


1509.jpg (115.4 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Yes and that doesnt work thats why I posed this question. I assume it is becuase of BEx structure being used in the report, Any thoughts ?

Thanks

0

OK. The behavoir of structures is often different.

And if you trie to use a hard filter on a condition like

if (ISNULL(Sum(<measure>)) = 1) then 1 else 0?

Grtz

0