Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Divide by 1000000 and set the custom format to #,##0 M
Divide by 1000000 and set the custom format to #,##0 M
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.