Forum Discussion

stephenkf's avatar
stephenkf
New Contributor
2 years ago

Cube View Cell Formatting

In this Cube View I'm building there are multiple columns - some of them amounts and some percentages. I tried to put the percentage and decimal formatting for those respective columns in the column cell format. However, that formatting is being overridden by the row formatting. I'm trying to get the cell formatting to do no decimals and no percentage signs for the cells that don't need it and decimals and percentages for cells that need it. Please provide some guidance! I attached a screenshot below:

 

Cube View
  • db_pdx's avatar
    db_pdx
    Valued Contributor
    2 years ago

    Hi stephenkf: row/column overrides are certainly a way to fix this.  However, you might want to do a more fundamental review of your formatting structure.  If possible, set the standard formatting in the Cube View Default section, then go down the path of column specific formatting, row formatting, and then overrides as needed.

    General reminder: formatting is applied in the following order:

    • Application Default
    • Cube View Default
    • Column Formatting
    • Row Formatting
    • Column Overrides
    • Row Overrides
  • tsequeira's avatar
    tsequeira
    New Contributor
    2 years ago

    Hi!

    Please follow these steps:

    1) select the column you want to change the cell formatting;

    2) select "row overrides" tab;

    3) In the "row range" fill the name of the row

    4) in the cell format do the changes you want