format code
sales figures are displayed as 2345.0000 1234.0000 how to get it displayed as 2.345k 1.234k
May 15th, 2012 6:59am

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"
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 7:14am

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
May 15th, 2012 7:24am

is there anything i can do the expression =fields!netsales.value to get those values
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 7:31am

I am getting the ouput as 3,.123k 4,.234k when i place that in format code
May 15th, 2012 7:46am

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
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 7:49am

that is working when i removed ',' there. can i get the format code for two precision values that is 2.34 1.23
May 15th, 2012 7:59am

Hi There please try this one =cstr(round(2345.0000/1000,4))+"K" for four decimal place =cstr(round(2345.0000/1000,2))+"K" for two decimal palce I hope this will help Many thanks Syed
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 8:48am

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
May 15th, 2012 2:30pm

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
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 5:38am

Hi There =iif(round(2345.0000/1000,2)<>0 ,cstr(round(2345.0000/1000,2))+"K" ,nothing) please try this one =iif(round(2345.0000/1000,2)<>0 ,cstr(round(2345.0000/1000,2))+"K" ,nothing) =iif(round(2345.0000/1000,2)<>0 ,cstr(round(2345.0000/1000,2))+"K" ,0) --if you wanted to display just 0 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.
May 16th, 2012 6:15am

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"
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2012 6:57am

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";
May 17th, 2012 4:15pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics