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!

[former_member193143]

Hello Albert,

Completely agree with Shrikant Jadhav  

But I am wondering how come you will get values only for local members..?

in which way you are calculating local member..?

Thank you very much..

Saida Reddy Gogireddy

[albert_prats]

Thanks for your responses.

I have this issue for the icmatching report. First column is the ENTITY-INTERCO (E_XXXX vs I_YYYY) relationship. The local Member is a RetrieveData for counterpart (E_YYYY vs I_XXXX).

Now, I'm doing this functionality with VBA, but the report is very slow because it has some Exel formulas.

Thanks!