LinkedIn
Twitter
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.
