What does ['$#,##0'] means in following script ??

[nikhilgarg]

Hey,

Can anyone tell me why is this ['$#,##0'] used in following script ?? What does every letter of it denotes ??

='Actual : ' & num(sum({<[Expense Category] = {'Food'}>} Amount), '$#,##0')

Thanks

[deepakqlikview_123]

$#,##0 will denote number uptp 4 palces like $1,234 etc.

This is simply formatting

[sushil353]

Hi,

This is for number formatting.

$ sign will be added to the starting of no..

#,##0 represents that a coma ','  will come on thousand point.

0 represent no decimal value will come..

Try using in text box: =num(2132.31,'$#,##0')

HTH

Sushil

[#4]

Money Format...

out put will be

$1,000

$10,000

$2,005

[anbu1984 · Accepted solution]

$#,##0 - Format of the number with prefix $ and 0 at the end round digits after decimal point

Num(1111111,'$#,##0') -- $1,111,111

Num(1111111.9,'$#,##0') -- $1,111,112

Num(1111,'$#,##0') -- $1,111

Num(111,'$#,##0') -- $111

Num(111.1,'$#,##0') -- $111

[SunilChauhan]

its mean you are converting  sum({<[Expense Category] = {'Food'}>} Amount) into format of 1,234 i.e Interger in Number Tab.

$ is just syblol for denoting amount in dollar.

hope this helps

[maxgro]

to test number formatting

goto number tab in a chart

set a number format

and see the result (preview and format pattern) at the right