Developing a LiveDoc in German and running into issues with German number formats.
To get the format 1.234 I enter in the Format tab, Custom Types: #.##0, (variable Type is Integer).
The issue is that #.##0, adds a leading period for values under 1,000 (e.g., .234 instead of 234).
I’ve tried various things to remove the leading period but can’t find a solution that works for values equal or greater than 1000 and values less than 1000. Any suggestions or solutions for this?
Best answer by LMaddock
Hi Michele,
I’ve reached out to our engineers and below are the 2 things you can try:
1. Use an if statement to control the formatting. Something like
If([[variable]]<1000,text([[variable]],”###”),text([[variable]],”#.##0”)
2. or you can use excel custom formatting: [<1000]#,##0;[>=1000]#.##0, excel formatting has a built in way to format different number sizes differently
Please let me know if this solves your issue.
Hi Michele,
I’ve reached out to our engineers and below are the 2 things you can try:
1. Use an if statement to control the formatting. Something like
If([[variable]]<1000,text([[variable]],”###”),text([[variable]],”#.##0”)
2. or you can use excel custom formatting: [<1000]#,##0;[>=1000]#.##0, excel formatting has a built in way to format different number sizes differently
Please let me know if this solves your issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
