Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
just add
'$ ' & expression
In your case
='$ ' & sum(revenue)
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
In Text object write like
=Money( sum(revenue), '$ #,##0 ', '.' , ',' )
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
You can use
=Money(sum(revenue)), '$#,##0' )
='$'&money(sum(revenue),'##.##')
OR
=money(sum(revenue),'$##.##')
Use Num function like
Eg
=num(10000.44444 ,'#.###')
If you use Money then
=Num( Money( sum(revenue), '$ #,##0 ', '.' , ',' ) ,'#.###')
'$' & (sum(ProjectedSales_modified) +(sum(ProjectedSales_modified) *($(Vprojected)/100)))
how to decrese the Decimals for the Above expression