Tag Archives: custom format

Number format in MicroStrategy

Hello there!

My friend Diogo Martins, told me a simple but powerful custom formatting to numbers that can help you so much!

Here is the tip:

Think that you have a Profit metric with a number like this: 1.304.141

And you want to divide that by 1000.

You just have to:

  1. Format the value and go to Custom
  2. Add a format like: 0,

Capturar

And now you will get your number like: 1304

The trick is the comma (,) at the end.

If you add 1 comma you will dividing by 1.000

If you add 2 commas you will dividing by 1.000.000

And so on…

So, just add commas after the 0 (for number) and you will format your number in a much better way than dividing it in your metric.

Hope it helps!

God bless you!

Erasing custom formats

Hello there!

Today I’m going to talk about how to remove custom formats that you created to format the values.

When you add a new custom format in MicroStrategy it says there until you remove in regedit.

pic

To remove those custom formats, you just have to:

1. Go to regedit (Start -> Execute -> write regedit and hit enter)

2. Go to:  HKEY_CURRENT_USER\Software\MicroStrategy\DSS Agent\Formatting Properties Dialog in the Custom_Formatting_X Key

3. Erase the Custom_formatting_x registries.

pic

Now when you won’t see that custom format in MicroStrategy anymore.

pic2

That’s it.

Hope it helps!

God bless you!