Forum Discussion

Ranvir06's avatar
Ranvir06
New Contributor II
2 years ago

Remove the zero from empty row in excel report format

Dear Community, we have requirement to remove the zero from empty row when it is displayed in excel format.  As shown in the picture for empty row "0" should not present. Any solutions to thi...
Cube View
Parameters
Reports
ryannelissa's avatar
ryannelissa
New Contributor III
2 years ago

You can set your number formatting to this for the blank row:

ExcelNumberFormat = [" ";" ";" "]

This will yield a blank regardless of any number or 0 that is rendered. 

  • Ranvir06's avatar
    Ranvir06
    New Contributor II
    2 years ago

    Hi Ryannelissa, Thank you for the idea but we have one issue with this idea.

    As mentioned in above image we are able to remove zero from the row but when we click in the row it gets displayed as 0. Any ideas to this will be very helpful.

    Thank You