Convert Percentage/Decimals to Basis Points in CubeView

[Mustafa_A]

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,

[db_pdx · Accepted solution]

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

[tsandi]

@Mustafa_A  If dp_pdx asnwer is correct please mark it as a solution

Thanks