08-11-2022 09:29 AM - last edited on 05-24-2023 12:22 PM by JackLacava
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.
08-12-2022 04:33 PM
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
08-12-2022 04:37 PM
In case it is not obvious, you can hide [Column 1].
08-15-2022 07:26 AM - edited 08-15-2022 07:27 AM
Is there a way to do this without column math? Using column math prevents the drill down functionality.
Cheers!
08-16-2022 02:27 PM
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.
08-16-2022 02:48 PM
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.