Numbers with Leading Zeros

I have a report where one of the columns can be either text and/or numbers.   Sometimes it is all numbers with leading zeros.
It is a flat format report and I am using version of Flexmonster.
When the column is all numbers it treats it as the default number format and loses the leading zeros.
Example data is
Column_1 Column_2
ABCD       000123456789
EFGH        000987654321
The Flat report shows:
Column_1 Column_2
ABCD       123 456 789
EFGH        987 654 321
If I use the filter for Column_2 it shows the values without the spaces and with the leading zeros. 
I need the report to show the values as they are in the data (i.e. with leading zeros and without the thousand space separator).
The JSON saved via Flemonster is attached – I have changed the filelocation only.

2 answers

Tanya Gryshko Flexmonster October 11, 2018

Hello, Paul,
You can override the default number format and set the necessary values here. For more details, refer to this article:!default
By the way, a lot of useful information can be found in our docs section:

Paul Young October 11, 2018

Thank you for your reply.
Unfortunately it is not a measure.  It is either a row or column which can contain any alphanumeric values. 
I have tried using the measure format and can define the thousand separator appropriately but cannot maintain the leading zeros.
In this situation, where I have the issue, it is all numeric with leading zeros.  It needs to be treated as a string and the actual value displayed.
I have tried searching your documents and forums for the solutions but have been unable to find one.

Please login or Register to Submit Answer