Lakhs and Crores Format

I want to Displaying Lakhs and Crores in results. but it shows million format only , how to change the indian decimal format…

Hi!

I did not know what “Lakhs and Crores” meant before seeing this post. I looked it up and now I see that these words refer to a different way of placing commas in numbers.

I don’t think AppSheet supports this kind of display. However, it may be possible to display the numbers as text with the proper comma placement. Here’s an example of an approach:

ifs(
len(text([Numbers]))<7,
text([Numbers]),
len(text([Numbers]))=7,
concatenate(left(text([Numbers]),1),",",right(text([Numbers]),6)),
len(text([Numbers]))>7,
“And so on”)

This produces the following:

“And so on” means that more “if” conditions are needed for larger numbers of digits.

If many people in India will use AppSheet and if it is important to place commas differently there, this kind of option might be needed in the platform. My method has some drawbacks. In addition to being complicated, the text will be aligned to the left, not the right.

2 Likes