Remove Empty and zero values is not working in my report

[former_member289786]

i checked the option to remove empty and zero values for the rows in report editor.But still rows with empty zeroes are not getting removed

[former_member186338]

Sorry, but try to be more professional:

- Detailed product version and SP

- Report screenshot

- Model information

...

[former_member289786]

when i unchecked the set default value to zero option in report editor.Remove empty and zero is working correctly.But empty cells are without "-".So i want to apply "-" in the place of empty cells.

[former_member186338]

Sorry, have to repeat third time:

IN MY SAMPLE EVERYTHING IS WORKING CORRECTLY WITH DEFAULT VALUE SET TO "0"

May be you have some issue with particular AO SP. Upgrade to latest!

[former_member289786]

is there any way to put dashes in the places of empty cells.

[former_member186338]

Sorry, but what do you want to achieve???

If you set default value to 0 Remove empty and zero will work correctly!

And you will have "-" in empty cells...

[former_member186338]

Unable to reproduce! In my test everything is working as expected:

After setting Remove empty and zero:

And for sure, without "Set default value" empty rows are also removed!

[former_member186338]

P.S. Original report with both options disabled:

[former_member289786]

screen.png

When i am unchecked this above option in screenshot.Remove empty and zero values is working.But all blank cells are blank without zero that is the other challenge in the report.When i check the above option.Report is not removing zeroes and Empty.

[former_member289786]

I created some test reports in which all columns have zero values.Yes here gettting removed empty and zero values.

[former_member186338]

Sorry, then you have issues with this particular report!

Try to recreate it! Check all columns...

[former_member186338]

Please create some test reports!

Ensure that all columns has zero values...

[former_member289786]

Hi Vadim,

Sorry for the incomplete information.

- Detailed product version and SP- BPC 10.1 Standard Netweaver

-- Report screenshot

Model information-Planning model type