Convert Percentage/Decimals to Basis Points in CubeView

Forum|Forum|4 years ago
December 13, 2021
2 replies
0 views

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

Best answer by db_pdx

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

D

db_pdxAnswer

Contributor

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