Skip to main content
Newcomer
Aug 3, 2023 6:46 AM UTC

Cube View Formatting

Hi All,

 

I have created a Cube view which has  negative values in few cells with parenthesis format in OneStream, when i try to export the repot to an Excel am not getting the same format in Excel instead am getting "-" in Excel. I need the same format in excel while exporting. Can anyone suggest the formatting settings how to get that.

 

Please find the below snaps for reference.

New_Member_0-1691045101718.png

 

 

New_Member_1-1691045119013.png

 

 

 

Thanks in Advance.

    6 replies

    aricgresko
    Veteran
    Aug 3, 2023 12:25 PM UTC

    Check your Cell Format within Formatting to ensure you have Number Formats the same under General, Excel, and Reporting.  Best practice would be to have these formats within a literal parameter that you assign to the Cube View to drive consistent number formatting.  

    MikeG
    Contributor
    Aug 3, 2023 12:53 PM UTC

    NumberFormat = [#,###,0;(#,###,0)], ExcelNumberFormat = [#,###,0;(#,###,0)]

     

    MikeG_0-1691067140883.png

    aricgresko  is correct.  It looks like this.  

    Hope this helps.

    STDNAuthor
    Newcomer
    Aug 3, 2023 1:08 PM UTC

    Hi Mike

     

    Thanks for your response, i tried the Excel format you shared in the Cube View Excel formatting but i am getting below. Please find the below snap for your reference and suggest on this.

     

    New_Member_0-1691068089680.png

     

     

     

    Thanks.

    MikeG
    Contributor
    Aug 3, 2023 1:26 PM UTC

    Here is one I'm using in the application I'm working on now.  This one has a hyphen for zeroes which you can remove if you don't want that.

    NumberFormat = [#,###,0;(#,###,0);"-"], ExcelNumberFormat = [#,##0;(#,##0);" - "], ReportNoDataNumberFormat = [" - "], ReportNumericBindingFormat = [{0:#,##0;(#,##0);" - "}]
     
    That will cover Data Explorer, Excel, and Report (PDF) views.