Skip to main content
N
Nitishkrish16
Newcomer
May 11, 2023
Solved

Report displaying 0s for Blank Row and Blank Column

  • May 11, 2023
  • 2 replies
  • 0 views

Dear Community Users, 

We have Blank rows and Blank Columns for the space convention. I'm getting 0s for both blank rows and columns while generating the report. I used below condition: and even tried hard coding 'ReportNoDataNumberFormat = #' in all blank rows and columns. Couldn't be able to resolve it. Any solutions to this are really appreciated. Thanks. 

If (RowName Contains 'Blank') And (ColName Contains 'Blank') Then
ReportNoDataNumberFormat = #
Else
ReportNoDataNumberFormat = [$#,###,0.00;($#,###,0.00);0.00]
End If

Best answer by JackLacava

Try this approach (changing your condition of course): https://community.onestreamsoftware.com/t5/Reporting/CubeView-not-displaying-literal-value/m-p/19277#M3022

2 replies

J
OneStream Employee
JackLacavaOneStream EmployeeAnswer
OneStream Employee
May 11, 2023

Try this approach (changing your condition of course): https://community.onestreamsoftware.com/t5/Reporting/CubeView-not-displaying-literal-value/m-p/19277#M3022

    Mike_Sabourin
    Mike_Sabourin
    Contributor
    May 11, 2023

    My assumption is that you are using these as spacers, meaning none of the rows/columns should have data. What I typically do is set the account to A#None. There shouldn't be data there at all. Or I choose a time that doesn't hold data. For either option, include the Name function like: T#2014:Name ( ). Important, there has to be a space between the parentheses for it to work.

     

      Terms & ConditionsAccessibility statement