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