Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
4 years ago

Convert Percentage/Decimals to Basis Points in CubeView

Dear Community - Is there a way to convert to Basis Points within Cube View? I'm sure there must be a setting. Any help will be appreciated.   Thanks,
Cube View
  • db_pdx's avatar
    db_pdx
    4 years ago

    Hi Mustafa_A: custom number formatting, combined with standard scaling, is likely the easiest approach.  You'll apply this to the specific % variance column/row that contains real decimal values.

    NumberFormat = [#,##0" bps";(#,##0" bps");0" bps"], Scale = -4

    If you are curious about more formatting options this is a decent guide: https://exceljet.net/custom-number-formats

     

db_pdx's avatar
db_pdx
Valued Contributor
4 years ago

Hi Mustafa_A: custom number formatting, combined with standard scaling, is likely the easiest approach.  You'll apply this to the specific % variance column/row that contains real decimal values.

NumberFormat = [#,##0" bps";(#,##0" bps");0" bps"], Scale = -4

If you are curious about more formatting options this is a decent guide: https://exceljet.net/custom-number-formats