-
1. Re: Labeling a pie chart
Jonathan Drummey
Dec 4, 2012 12:43 PM
1 of 1 people found this helpfulSee the attached. I used RAWSQL to format the numbers, that generally works easier in cases like this where we'd want to have commas or periods.
Jonathan
-
2. Re: Labeling a pie chart
Thank you for your response.
The "messy label" formula works for me, only it puts a bunch to decimal places at the end of the revenue number that I don't want there. I'm not sure what RAWSQL is so I can't seem to use that formula, I get a data error.
Is there an easy way to get rid of those decimal places? Otherwise it works great.
-
3. Re: Labeling a pie chart
On that same topic, I realized I have another number I want to add to that lable--I would also like the label to show a caluculated field I created for % of total revenue--is it possible to add a third piece of data to the label?
Thank you.
-
4. Re: Labeling a pie chart
Chaya,
Change Jonathan's 'Label' field to this:
ATTR([Category]) + "
$" + RAWSQL_STR("FORMAT(%1,'##,##0')",SUM([Sales]))+ "
" + RAWSQL_STR("FORMAT(%1,'percent')",[Profit Ratio])
Gives you this:
--Shawn
-
5. Re: Labeling a pie chart
I think maybe this is getting way over my head--it doesn't want to use RAWSQL and is telling me something about applying it to table calculations and fields from multiple data sources.
-
6. Re: Labeling a pie chart
Hi Chaya, don't give up yet. It would be best if you posted a packaged workbook with some sample data so we could see the structure of your data and what might be causing you problems. But if you can't do that provide a screen shot of your whole screen with the error you're getting so we can see what data sources you're using and what pills you have on what shelves. Like this:
(This is 8, your's will look different.)
--Shawn
-
7. Re: Labeling a pie chart
Thanks so much for trying to help.
Here is a screen shot of what I get when I try to use that formula, any advice?
-
8. Re: Labeling a pie chart
Chaya, interesting I hadn't run into that before. So let's try a different route:
ATTR([CUSR_5]) + "
$" + RAWSQL_STR("FORMAT(%1,'##,##0')",SUM([Revenue from Scans]))+ "
" + STR(ROUND([Revenue % Total]*100,2))
You may or may not need that *100. Also if you want more or fewer decimals change that last 2.
--Shawn
-
9. Re: Labeling a pie chart
That forumula works better, no errors in that, but i get a data error
SQL Server database error 0x80040E14: 'FORMAT' is not a recognized built-in function name.
Error retrieving collation for [sqlserver.41198.484064351855].[TEMP(TC_1)].
-
10. Re: Labeling a pie chart
OK, let's just get rid of the RAWSQL altogether. Try this:
ATTR([CUSR_5]) + "
$" + STR(ROUND(LOOKUP(SUM([Revenue from Scans]),0),0))+ "
" + STR(ROUND([Revenue % Total]*100,2))
That should work. Let me know.
--Shawn
-
11. Re: Labeling a pie chart
Perfect!!! Thank you. And I even figured out myself how to add the % sign in.
Thank you for sticking with me.
-
-
13. Re: Labeling a pie chart
Hi Shawn,
I tried the formula in your previous comment but the numbers in the result at my end are not comma separated. I have always run into this problem.
Screenshot is attached. Is something i am missing in the formula? Please suggest.
-
-
14. Re: Labeling a pie chart
Trishia, thanks for searching the forums before posting a question! That's much appreciated. However this thread is almost 3 years old. It was probably back in the 6.0 or 6.1 days, which is many releases ago. So what worked back then won't necessarily work now, as much has changed in the product.
If your Parameter only has two options, one a count and the other currency, then you can use a different trick. This uses the negative number space in a custom format to get the two different formats. Do you only have two formats?
There is another workaround involving a MIN(1) trick that creates a scaffold to hang your different values on. But this is a little tricky, and will definitely require you to post a sample packaged workbook, for us to help you set it up.
Cheers,
--Shawn
