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
⋅ 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
