Format of KPI object

[Anonymous]

Hi !

Is it possible to show 1,8G as 1 801M in a KPI-object? I have the value 1 801 002 003 and when I use the KPI object it's shown as 1,8G and that is correct because G stands for Giga. But I would like to show the value as 1 801 M instead. The is also correct because the values are the same.

I have tried to divide the value with 1000 but when I do that it's displayed as 1,8M and that is not what I'm looking for.

I have tried with a textbox and in that textbox I have full control of how the value should be displayed. But I would like to use the KPI-object.

Any ideas?

Best regards

Peter

[Gysbert_Wassenaar · Accepted solution]

Divide by 1000000 and set the custom format to #,##0 M

[Anonymous]

Thank you. It's almost what I'm looking for but I don't want the comma/ thousandseparator to show. It should be "1 801" not "1,801". I think this solution is good enough.