# Number format in Indian numbering system

Member

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:

• Coach

@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.

```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

** Did this solve your problem? Accept it as a solution! ✔️**

• Coach

@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.

```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