Can we change values as Millions, Thousands, etc,.
Can we change values as Millions, Thousands, etc,. dynamically
When you need to change number formatting dynamically you can either use toolbar functionality (Format -> Format cells) or you can use
setFormat API call. The
setFormat API call has the following signature setFormat(format: Object, measureUniqueName: String). Please find the information on how to compose the format object here: https://www.webdatarocks.com/doc/number-formatting/. In case you need to edit the existing formatting, you can run
getFormat(measureUniqueName: String) to get the formatting and then use
setFormat() to rewrite it.
Please let us know if it solves the case.
Thanks for the quick response,
I need to present numeric value 20,00,000(2 Million) as below based on user selection
If User select show in millions then value is 2.00M
If User select show in Lakhs then value is 20.00L
If User select show in Thousands then value is 2000.00L
Is this possible with number formatting?
Thank you for your feedback. Currently, there is no native support for such formatting. However, you can easily implement your own custom formatting using
customizeCell approach: https://www.webdatarocks.com/doc/customizecell/.
Please let us know if everything works fine for you.