Num formate..

[Satish8]

Hi All,

num(Sum(Sales),'# ##0,00', ',' ,' ') Here I'm using this num format value this one 14 758,22 but requirement

14 758 22 remove comma (,) . Here separate decimal and thousands space

[marcus_sommer]

AFAIK must the separators for thousands and decimal be different. But there are various white-space chars available which may added like:

= num(14758.22, '# ##0' & chr(160) & '00', chr(160), ' ')

[Vegar]

You could just multiple your sum by 10 and skip the decimals completly.

num(Sum(Sales)*10,'# ##0')