Abbreviated Number with same number of decimals?

Hmmm, maybe with some try and error using this info:

https://docs.celonis.com/en/number,-date,-and-time-formatting.html

something like ,.4r2f? No idea if it will work....

Best luck!

Hi Guillermo,

thanks a lot for your quick reply.

Unfortunately this does not work. Combinations of the number formats generally do not seem to work. Does anyone else have an idea?

Thanks in advance!

Well, a "workaround" would be to convert it to string and format it as you please....

@Jonas Scheidel - Try this format .3~s

Thanks @kailash.potha12  I have tried this already but also doesn't work.

Hello,

have you already tried it this way ',.2f' ? Granting that you want the comma as thousands seperator..

BR,

Marco

Hello @marco.marso 

thanks for your reply. But with  ',.2f' you lose the format for abbreviation -> target format: 8.07k or 17.01k or 100.25k .... -> same Number of Decimals + Abbreviation (k)

Best,

Jonas

ofc. my bad.

Is what I do as a workaround, here is the script I use:

CASE 

WHEN table.column < 1000000000000 AND table.column >= 1000000000 THEN  table.column/1000000000 || 'b' 

  WHEN table.column < 1000000000 AND table.column >= 1000000 THEN  table.column/1000000 || 'm'

  WHEN table.column < 1000000 AND table.column >= 1000 THEN  table.column/1000 || 'k'

  --WHEN table.column < 1000 AND table.column >= 0 THEN  table.column || 'u'

  ELSE table.column 

END

commented out the units as not needed.