Number format in Indian numbering system

LearningNinja
LearningNinja Member
in Cards, Dashboards, Stories

Hello,

How can I have the numbers presented in Indian numbering system like Crores, Lakhs, Thousands?

I understand we can do the formatting using the custom format and comma separator, but I would like to print Crores, Lakhs instead of K (thousand), M (mill) on a card (graph chart, single value)

TIA.

Tagged:

Best Answer

  • david_cunningham
    david_cunningham Coach
    Answer ✓

    @LearningNinja - I'm not super familiar with the Indian numbering system, so did my best to provide a good answer for you. You may need to adapt/adjust this. This was the reference material I used.

    https://en.wikipedia.org/wiki/Indian_numbering_system 

    CASE
    
  WHEN LENGTH(ROUND(value)) < 6 then value
    
  WHEN LENGTH(ROUND(value)) < 8 then CONCAT(value/100000,' Lakh')
    
  WHEN LENGTH(ROUND(value)) < 10 then CONCAT(value/10000000,' Crore')
    
  WHEN LENGTH(ROUND(value)) < 12 then CONCAT(value/1000000000,' Arab')
    
END

    Screen Shot 2024-05-06 at 1.10.47 AM.png

    You could also expand this to format the numbers < 1 Lakh to include commas.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • david_cunningham
    david_cunningham Coach
    Answer ✓

    @LearningNinja - I'm not super familiar with the Indian numbering system, so did my best to provide a good answer for you. You may need to adapt/adjust this. This was the reference material I used.

    https://en.wikipedia.org/wiki/Indian_numbering_system 

    CASE
    
  WHEN LENGTH(ROUND(value)) < 6 then value
    
  WHEN LENGTH(ROUND(value)) < 8 then CONCAT(value/100000,' Lakh')
    
  WHEN LENGTH(ROUND(value)) < 10 then CONCAT(value/10000000,' Crore')
    
  WHEN LENGTH(ROUND(value)) < 12 then CONCAT(value/1000000000,' Arab')
    
END

    Screen Shot 2024-05-06 at 1.10.47 AM.png

    You could also expand this to format the numbers < 1 Lakh to include commas.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Categories