Number format in Indian numbering system

LearningNinja

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.

david_cunningham

@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

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

david_cunningham

@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

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