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
3 years ago

If we don't use the GetDataCell formula in the report, we could use the GetDataCell formula in the account formula.

WARNING: I would never recommend adding zero to static account formula. You will populate many cells of data with zeros!

 

DYNAMIC CALC: But you could add it to a dynamic calculation account. And this solution might make sense for a short list of accounts. But the longer the list of accounts, the higher the 'cost' of this answer. Both in terms of report speed and chart of accounts volume.

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

    I wouldn't  create new account to accomodate this as this would require a lot of maintenance. From what I am understanding is that there is currently no supression setting for this.

     

    Thanks for the insight.