Can we change values as Millions, Thousands, etc,.


Can we change values as Millions, Thousands, etc,. dynamically

3 answers

WebDataRocks Team WebDataRocks August 13, 2018

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: 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.
WebDataRocks Team

Ramarkishna August 13, 2018

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?

WebDataRocks Team WebDataRocks August 14, 2018

Hello Ramarkishna,
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:
Please let us know if everything works fine for you.
WebDataRocks Team