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.
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.
Do you have it on the Cell Format on the main Cube View properties tab? The order of operations for what Cell Format wins is 1) Cube View Properties, 2) Column Cell Format, 3) Row Cell Format, 4) Column - Row Overrides, 5) Row - Column Overrides. Do you have other Cell Formatting anywhere else in the CV? That syntax works.