Number Format (Thousand Separator)

nikeman77

Hi All,

I got an amount in decimal to 555777.00 which i managed to truncate into 555777. using [myInt := Amount Div 1;]

However, i would like further to change it into 555,777 with a thousand separator how can it be done ?

einsTeIn.NET

You could use Attribute 1000Character in FORMAT function.

FORMAT(YourDec,0,'<Sign><Integer Thousand><1000Character,,>')

nikeman77

You could use

Attribute

1000Character in FORMAT function.

sorry what does the attribute meaning ?

einsTeIn.NET

1000Character is one of the format attributes of function FORMAT. Take a look at my code example.

vaprog

Also take a look at the entry for the Format property in the C/SIDE Reference Guide (online help).

nikeman77

hi einsTeIn.NET,
do you mean put the code: FORMAT(YourDec,0,'<Sign><Integer Thousand><1000Character,,>') in
my report> properties> SourceExpr: FORMAT(YourDec,0,'<Sign><Integer Thousand><1000Character,,>') ? or
FORMAT: FORMAT(YourDec,0,'<Sign><Integer Thousand><1000Character,,>')