Skip to Content
0
Former Member
Jan 26, 2007 at 06:09 AM

Display zero values and display blank if no data in ALV

3531 Views

Is there a way to suppress cells with numeric values in an ALV list? I am expecting the following:

1) non-zero value -> display

2) zero value -> display

3) no data -> blank

I have to write the same output to Excel and would want the Excel download to reflect the above scenarios as well.

I tried using 'no-zero' in my fieldcatalog but columns with zero values appear as blank instead of 0.0. Ideally, zero values should still appear in the ALV list output.

Any suggestions will be greatly appreciated.

Thanks.