Supress Zero

[albert_prats]

Hi Experts,

I have a very clear and simply question.

Suppose that you have a report with local members. For some rows, the only element that have data is LM. Is possible that Supress Zero Option doesn't supress this rows?

	INTERCO	Local Member
ENTITY 1	100
ENTITY 2		90
ENTITY 3		60
ENTITY 4	100

With Supress zero funcionality, the report will only display rows 1 and 4.

In this case, I need to desplay all rows.

Thanks!

[Shrikant_Jadhav]

Hi Albert,

As a standard behavior "Suppress zero" is applicable to only OLAP member.

To fulfill your requirement, you can use VBA.

Shri