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