Forum Discussion

STDN's avatar
STDN
New Contributor III
2 years ago

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.

 

 

 

 

 

Thanks in Advance.

Cube View
Excel Add In
  • aricgresko's avatar
    aricgresko
    Contributor III
    2 years ago

    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's avatar
    MikeG
    Contributor III
    2 years ago

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

     

    aricgresko  is correct.  It looks like this.  

    Hope this helps.

    • STDN's avatar
      STDN
      New Contributor III
      2 years ago

      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.

       

       

       

       

      Thanks.

      • MikeG's avatar
        MikeG
        Contributor III
        2 years ago

        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.