none
Number format to show thousand (k)

    Question

  • Hi, i want to format the number in the textbox in thousand unit.

    For example,

    1000 -> 1k

    510000 -> 510k

    Could anyone help me build the expression for the number format to achieve this ? 

    Thanks,

    Monday, April 01, 2013 12:39 PM

Answers

  • Hi

    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.


    • Proposed as answer by vishal0soni Tuesday, April 02, 2013 5:22 AM
    • Marked as answer by bonosungho Tuesday, April 02, 2013 7:51 AM
    Monday, April 01, 2013 12:58 PM

All replies

  • Hi

    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.


    • Proposed as answer by vishal0soni Tuesday, April 02, 2013 5:22 AM
    • Marked as answer by bonosungho Tuesday, April 02, 2013 7:51 AM
    Monday, April 01, 2013 12:58 PM
  • Along those lines, you can try something like this:

    =

    "$" & format(Sum(Fields!INVOICEAMOUNT.Value)/1000,"0.0")  & "K"

    Thursday, April 10, 2014 12:39 AM