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]

Hi,

try this:

= Num(sum(revenue),'$ #,#0.0; -$ #,##0.0') and thats all.

If you wnat 2 decimals use '$ #,##0.00; -$ #,##0.00' or 3 decimals '$ #,##0.000; -$ #,##0.000' or 1 decimal '$ #,##0.0; -$ #,##0.0'

best regards.

[#3]

Hi,

try this:

num(

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

,'$ #,#0.0; -$ #,##0.0')

If you wnat 2 decimals use '$ #,##0.00; -$ #,##0.00' or 3 decimals '$ #,##0.000; -$ #,##0.000' or 1 decimal '$ #,##0.0; -$ #,##0.0'

best regards.

[#4]

without decimals i want to rounding the number is it possible and how to achieve this

[PrashantSangle]

Hi,

Yes you can round it using floor()

Regards,

[#6]

jeje sure,

num(

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

,'$ #,#0; -$ #,##0')

with '$ #,#0; -$ #,##0' you get an Int number.

best regards.

[#7]

Kishore

just use

=money(100000.44,'$#,##0')

the part of the function ,'$#,##0' describes the format of the number

Richard

PS please don't forget to mark question as answered, or mark the helpful or correct answers.