Number Format Problem

[pgalvezt]

Hello,

I have '$#,##0;$-#,##0' format number 

Show me this 67,554,987

But I want to change to '$#.##0;$-#.##0'

and show me this 67554987.520

I need to show this 67.554.987

Thanks!!

[SerhanKaraer]

Hello Pgalvezt,

It seems in your script, seperator values are defined as this way:

SET ThousandSep=',';
SET DecimalSep='.';

Either you can change them, or you can overwrite them by choosing custom format for the measure.

[pgalvezt · Accepted solution]

Finally I got it !!

Here the solution:

Num( Num#(If(Field=' TRUE',0,Field),' #,### ' , '.' , ' ' ),'#.###,0',',','.')

123.456.678