format code

All replies

• 

  

  0

  Sign in to vote

  either this:

  0,"."000"k"

  or

  #,"."000"k"

  bearing in mind that depending on your localisation/regional settings some regions use a "." as a thousands separator

  ---

  My Blog "Karl Beran's BI Mumble"

  • Proposed as answer by Karl Beran Tuesday, May 15, 2012 11:14 AM

  Tuesday, May 15, 2012 11:14 AM
• 

  

  0

  Sign in to vote

  i am using point labels to display the figures. I want the figures to be

  in the format of

  2.345k

  1.234k

  is there anyway, i can change the format code at point labels to display

  such values

  Tuesday, May 15, 2012 11:24 AM
• 

  

  0

  Sign in to vote

  is there anything i can do the expression

  =fields!netsales.value

  to get those values

  Tuesday, May 15, 2012 11:31 AM
• 

  

  0

  Sign in to vote

  I am getting the ouput as

  3,.123k

  4,.234k

  when i place that in format code

  Tuesday, May 15, 2012 11:46 AM
• 

  

  0

  Sign in to vote

  Hello,

  Below links will provide a lot of formatting examples. I hope it helps.

  http://msdn.microsoft.com/en-us/library/ms252080%28VS.80%29.aspx

  http://msdn.microsoft.com/en-us/library/ms157328.aspx

  Tuesday, May 15, 2012 11:49 AM
• 

  

  0

  Sign in to vote

  that is working when i removed ',' there.

  can i get the format code for two precision values

  that is

  2.34

  1.23

  Tuesday, May 15, 2012 11:59 AM
• 

  

  0

  Sign in to vote

  that is working fine. but there is one problem.

  with the above formula when used  in the bar chart, if there is no sales for any branch, then the bar will show up as 0k.

  user does not want 0k to be shown when there is no sales.

  the earlier formula 0"."000"k" suggested by Karl Beran is working fine. it is not showing up 0k when there is no sales for any branch.

  but the user want now for two precision places only after the decimal.

  0"."000"k is working for 3 decimal places. can we make any changes to it to get for two precision places

  Tuesday, May 15, 2012 6:30 PM
• 

  

  0

  Sign in to vote

  could anyone help with two precision values.
  for the values
  1234.0000
  21345.0000
  3456.0000

  the ouput should be
  1.23k
  21.34k
  3.45k

  Wednesday, May 16, 2012 9:38 AM
• 

  

  0

  Sign in to vote

  Syed,

  This isn't an advisable approach to this problem. As you are eliminating the underlying value from the report renderer, which means if you output to excel the values will become strings and can't be used in any formulas. Using a format mask is a preferred for this reason.

  ---

  My Blog "Karl Beran's BI Mumble"

  Thursday, May 17, 2012 10:55 AM
• 

  

  0

  Sign in to vote

  Hi karl

  Thanks for your suggestion

  Hi regavali

  Please use this one this will hopefully resolve your problem.

  Please use expression something like this
   
  Divide your amount by 1000 and round it for two decimal palace
  =round(6203045.0000/1000,2)
  and then please put format like this
  #.#0,"K";

  If you have any question please let me know.

  Many Thanks

  Syed Qazafi Anjum

  Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

  --Divide your amount by 1000 and round it for two decimal palace
  =round(6203045.0000/1000,2)
  and then please put format like this
  #.#0,"K"; 

  
  
  

  • Edited by Syed Qazafi Anjum Thursday, May 17, 2012 8:15 PM
  • Marked as answer by Mike Yin Monday, May 21, 2012 3:51 AM

  Thursday, May 17, 2012 8:14 PM