Hello All and Gysbert, I try to with you your expression with KPI object, but it is not displaying what I wanted, such as 34.2M or 23.3K etc, depending on values.
the following code Answered by Rob.
I am able apply below code for showing dynamic values with correct format, but I just need to add one decimal to values, can you please check below code, and help me how to add decimal point from below code.
I create a variable in the script like this:
SET vScaleNumber=if($1>1000000, num($1/1000000,'#,##0.000M')
And then use it in expressions like this: