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...
Cube View
Excel Add In
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.
      • STDN's avatar
        STDN
        New Contributor III
        2 years ago

        Hi Mike,

         

        I tried the same thing but still am not able to see the same thing in Excel report after export, do i need to changes/enable any settings?

         

         

        Thanks in Advance.