Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Numbers with Leading Zeros

Paul Young asked on October 10, 2018

Hi,
 
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 2.3.1.1 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.
 
Regards,
Paul

Attachments:
FlemonsterCreated.json

1 answer

Public
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: https://www.flexmonster.com/doc/number-formatting/#!default
By the way, a lot of useful information can be found in our docs section: https://www.flexmonster.com/doc/
Regards,
Tanya

Please login or Register to Submit Answer