how to add $ signs in my text box

[#1]

hi all,

i have written the expression in my text box to caluculate =sum(revenue) it show the revenue 100000 ..i want me to add $ in the number how can i acieve this without adding another text box any help highly appreciable..

[#2]

just add

'$ ' & expression

[#3 · Accepted solution]

In your case

='$ ' & sum(revenue)

[#4]

Use the Money function

For example

=money(Sum(revenue))

or

=money(Sum(Revenue),'$#,##0.00')  

to add the $ and format accordingly, result of your example would be $10,000.44

You can find other info on it under the online help, you just need to know there is a money() function to start with!

Richard

[its_anandrjs]

In Text object write like

=Money( sum(revenue), '$ #,##0 ', '.' , ',' )

[#6]

thanks for you quick reply it is working some more help if revenue is 10000.44444 i wont to decrese the decimals how to change

[#7]

You can use

=Money(sum(revenue)), '$#,##0' )

[anandathome]

='$'&money(sum(revenue),'##.##')

OR

=money(sum(revenue),'$##.##')

[its_anandrjs]

Use Num function like

Eg

=num(10000.44444 ,'#.###')

If you use Money then

=Num( Money( sum(revenue), '$ #,##0 ', '.' , ',' ) ,'#.###')

[#10]

'$' & (sum(ProjectedSales_modified) +(sum(ProjectedSales_modified) *($(Vprojected)/100)))

how to decrese the Decimals for the Above expression