Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
how shall I do to get the value 3342394 formatted in the KPI-object in the same
way as it is in the variable vG.KPI1 ?
kindly
Håkan
May be using Num() function
=Num(vG.KPI1, '# ###')
Then I get this:
Is it possible to share your sample app to look into?
Try this:
=Num(3231235, ' # ### ###', '.', ' ')
This is the result:
There is a space between the last two single quotes.
try this one num(3231235,'# ##0',',')
Hello all,
I have tested the different suggestions but it doesn´t work. I have also tested to change the format for
number on the pc but still the same result. The strange thing is that it works in the calculation but not
when showing the result in the KPI-object so it looks that the formatting for text in the chart doesn´t work.
kindly
Håkan
I am not sure what issue you are running into, but it seems to be working well here: