473,386 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

PivotChart Decimal Place on Fixed Number Format on Averaged Field

I have a pivotchart which I cause to take a huge list of people's test
percentiles and calculate the average for each year. I then display the
average above each bar. The problem is that there are too many numbers
after the decimal place for each figure. I went into the properties and
changed the number format to "fixed" but it doesn't give me the option
to change the number of decimal places that are used (it does every
where else in MS Office!). It seems that it just uses the regional
settings for the computer. But the problem I have in changing that is
that I have other pivotcharts in the same report that does something
similar but needs a different number of decimal places. Is there any
way around this without having to create another query to calculate the
average and then having the pivotchart display the info from the new
query (this is a huge database that I put together with many charts and
I don't want to have to redo the way that it works just because of this
decimal place issue)?

May 18 '06 #1
0 1839

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: TheWizard | last post by:
Hi, I suppose this is easy enough if you know how but I don't have any help files available. I need to set an output to a text box to two decimal places is there some sort of format command?...
21
by: Batista, Facundo | last post by:
Here I send it. Suggestions and all kinds of recomendations are more than welcomed. If it all goes ok, it'll be a PEP when I finish writing/modifying the code. Thank you. .. Facundo
17
by: John Bentley | last post by:
John Bentley: INTRO The phrase "decimal number" within a programming context is ambiguous. It could refer to the decimal datatype or the related but separate concept of a generic decimal number....
36
by: Andrew | last post by:
I trying to format my output to display a set number of decimal places. I have been trying to use the <iomanip> setprecision(), but that will only display the total number of digits. Can someone...
1
by: stuart | last post by:
I am trying to format a number in an unbound text field using the following format statement in the field's Exit event: txt11UnitWeight = Format(txt11UnitWeight, "00000.00") I want the number...
3
by: paulquinlan100 | last post by:
Hi I have a couple of calculated fields in a report, i've set the Decimal Places property to 0 and the format to General Number, however when previewing the report it still comes up with a...
2
by: Michael R | last post by:
Hello All. It's great to be in a place where people share their knowledge in a frendly way. It's seem to me unlikely for PivotChart not to have a certain feature. I didn't find it, and...
4
by: Todd | last post by:
I have a function that takes a double and truncates it to a specified number of decimal places. I've found that I have to add a small number to the input value otherwise I get errors due to the...
5
by: MyWaterloo | last post by:
I need to change the decimal value in one of my databases. Currently my company uses an ID system with nice whole numbers, i.e. no decimal numbers. Now my boss has this grand scheme to start using...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.