on
08-18-2021
02:29 PM
- edited on
09-14-2023
10:44 AM
by
JackLacava
Yes, default report formatting for Cube Views, PDFs, and Excel can be set in a number of different places.
Application Settings – Sets default formatting across the entire application
Cube View Settings – Sets the formatting specific to the cube view (overwrites Application settings)
Rows and Column Formats – Sets the formatting for specific rows and columns
Cell Formats – Sets the formatting for a specific cell
For number specific formatting to be standardized you can change the application wide settings under application settings à Number Format.
To get zeros instead of blanks select the “ #,###,0.00;(#,###,0.00);0.00” format
Source: Office Hours 2020-05-17 Partner Enablement