Skip to main content
Newcomer
May 11, 2023 7:32 AM UTC
Solved

Report displaying 0s for Blank Row and Blank Column

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

Employee - Sage
May 11, 2023 1:43 PM UTC

Try this approach (changing your condition of course): https://community.onestream.com/topic/show?tid=7755&fid=7

2 replies

Employee - Sage
May 11, 2023 1:43 PM UTC

Try this approach (changing your condition of course): https://community.onestream.com/topic/show?tid=7755&fid=7

Mike_Sabourin
Contributor
May 11, 2023 6:56 PM UTC

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.