Hi, i want to format the number in the textbox in thousand unit.
1000 -> 1k
510000 -> 510k
Could anyone help me build the expression for the number format to achieve this ?
Divide your field value by 1000 and append 'k' at the end of the expression.
eg: Fields!textbox11.value/1000 & 'k'
This will meet your requirement.
Please mark as answer if it suits your requirement.
Along those lines, you can try something like this:
"$" & format(Sum(Fields!INVOICEAMOUNT.Value)/1000,"0.0")
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?