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 this will be much helpful.

Thank You.

3 Replies

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor

    Hi Ranvir06 !
    How is the report generated? If it is using a cube view connection, please check under data and select the row of your cube view. You will find the option there.

     

  • ryannelissa's avatar
    ryannelissa
    New Contributor III

    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

      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