Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
i want to display only... but my case its different i used value list with multiple measure type so unable to achieve it
working perfectly thank you
what should be displayed if you select Format = $-Billion
$0 ???
actually I do not see your problem:
within the expression you already differentiate (by valuelist) and format ...
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.