Skip to main content
S
STDN
Newcomer
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

      aricgresko
      aricgresko
      Veteran
      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.  

        MikeG
        MikeG
        Contributor
        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
        Newcomer
        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.

          MikeG
          MikeG
          Contributor
          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