Forum Discussion

sohrabmemar's avatar
sohrabmemar
New Contributor
3 years ago

Display of 0's in rows with no data in OneStream AND excel Export

Hello,  How Can I have rows that have no data for a time period to display 0 instead of blank in OneStream as well as when exported to Excel. 
Reports
coneill's avatar
coneill
New Contributor III

Add a column that adds zero to the data column. [Null] + 0 = 0.

 

Cube View [Column 1] has the (sometimes null) data

Cube View [Column 2] = [Column 1] + 0 using a GetDataCell formula

 

coneill's avatar
coneill
New Contributor III
3 years ago

In case it is not obvious, you can hide [Column 1].

  • xtensibilitybro's avatar
    xtensibilitybro
    New Contributor III
    3 years ago

    Is there a way to do this without column math? Using column math prevents the drill down functionality. 

     

    Cheers!