comma seperator

[soniasweety]

Hi all,

i want  the result for  Number of deals   with 1,000  seperator.  with   starting dollor symbol   

like this:     $1,405  .....

for hardware and service and total   i need to remove the decimals   

for example   $818.90  is there i  want to be    $818  only  remove the two decimals

[prieper · Accepted solution]

If you need for display only: please use formatting option like "$#,##0.00" or "$#,##0".

If you really need to truncate the data you may use FLOOR(MyData) as expression. Formatting as above.

Peter

[soniasweety]

i want to display only... but my case its different i used value list  with multiple measure type so unable to  achieve it

[soniasweety]

working perfectly   thank you

[Frank_Hartmann]

what should be displayed if you select Format = $-Billion

$0 ???

[prieper]

actually I do not see your problem:

within the expression you already differentiate (by valuelist) and format ...

[soniasweety]

whatever the number either its billion or million or thousand  before number it should be dollor symbol

and count  with be comma seperator.    its working fine enough thanks.