Skip to main content
S
STDN
August 3, 2023

Cube View Formatting

  • August 3, 2023
  • 2 replies
  • 0 views

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.

    2 replies

    A
    aricgresko
    August 3, 2023

    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.  

    M
    MikeG
    August 3, 2023

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

     

    MikeG_0-1691067140883.png

    aricgresko  is correct.  It looks like this.  

    Hope this helps.

    S
    STDNAuthor
    August 3, 2023

    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.

    M
    MikeG
    August 3, 2023

    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.
    Terms & ConditionsAccessibility statement