Skip to main content
Question

Hi! I'm trying to format my currency KPIs as follows: 12345.67 -> £12.3M (note that the pound sign comes before the number and 'M' instead of 'k' for thousands. Additionally, 'MM' should be used for millions.)

  • March 22, 2023
  • 5 replies
  • 14 views

ward.brand
Level 3
Forum|alt.badge.img+7

imageI found this in Celonis documentation for the first part of the issue, but this only works for dollar-signs, whereas I'm using pounds.

5 replies

andré.tafur
Level 8
Forum|alt.badge.img+15

Hi Ward,

 

Please could you tell us which enviroment are you using? (View or Instrumentation Apps/Process Analytics)in order to better guide you.

 

Thank you


subhayu.monda12
Level 4
Forum|alt.badge.img+16

Screenshot 2023-03-23 115146If you want to use an abbreviated formatting style (##.#k) with the currency unit after the figure, you can add it like the way I have done in the above screenshot. You won't be able to add the currency unit before the figure if you want to use abbreviated formatting style. Also as per the documentation you have shared, I also found that it is only working with $ but that will be in decimals and not abbreviated.


ward.brand
Level 3
Forum|alt.badge.img+7
  • Author
  • Level 3
  • March 23, 2023

Hi Ward,

 

Please could you tell us which enviroment are you using? (View or Instrumentation Apps/Process Analytics)in order to better guide you.

 

Thank you

Hi André,

 

I'm trying to achieve this in the Studio environment within an analysis.


ward.brand
Level 3
Forum|alt.badge.img+7
  • Author
  • Level 3
  • March 23, 2023

Screenshot 2023-03-23 115146If you want to use an abbreviated formatting style (##.#k) with the currency unit after the figure, you can add it like the way I have done in the above screenshot. You won't be able to add the currency unit before the figure if you want to use abbreviated formatting style. Also as per the documentation you have shared, I also found that it is only working with $ but that will be in decimals and not abbreviated.

Hi Subhayu,

 

Thanks for your response. According to Celonis documentation, the '$,.2f' can be used to display values in local currency. This implies that local currency can be defined somewhere in Studio.


subhayu.monda12
Level 4
Forum|alt.badge.img+16

Ok, you should be able to define that in the parameter section of currency conversion script I think