Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nicolas_martin
Partner - Creator II
Partner - Creator II

Change decimal separator for the whole application

Hello,

I have an application with many metrics.

It was created with a spectific decimal separator and thousand separator.

Now, I'ld like to change these separators.

If I change the variables

SET ThousandSep='';

SET DecimalSep='.';

it'll change only the new expressions I'll create in the future, not the one already created.

Is there a way to simply apply the decimal / thousand separator for the whole application?

As I have a copy of the same application for more than 1 client, the best for me would be to have a parameter I can include in a parameter file. Each client would be able to have the format he wants.

1 Solution

Accepted Solutions
prieper
Master II
Master II

you may set number-properties across the document under Settings -> Document Properties ->Number.

Else you may create a variable toggling between e.g.

#.##0,00 and #,##0.00 etc

Your expression then will need to include NUM-command, the expression and your format, e.g.

NUM(SUM(Sales, '$(vMyFormat)')

Peter

View solution in original post

2 Replies
prieper
Master II
Master II

you may set number-properties across the document under Settings -> Document Properties ->Number.

Else you may create a variable toggling between e.g.

#.##0,00 and #,##0.00 etc

Your expression then will need to include NUM-command, the expression and your format, e.g.

NUM(SUM(Sales, '$(vMyFormat)')

Peter

nicolas_martin
Partner - Creator II
Partner - Creator II
Author

I think I'll use the "num()" workaround.