Data Analysis Views

D

Dots

I am creating custom views for my organization. When displaying the numeric
fields (ie: work, Actual work) How can I restrict to 2 decimal places only?

Thanks!
 
D

Dale Howard [MVP]

Dots --

This is easier than you think. Because the PivotTable is an Excel object,
you can apply default and custom Excel formatting to the numeric fields.
Here's how:

1. Open the Data Analysis view in editing mode.
2. Right-click on the Work or Actual Work column header and select the
Commands and Options item from the shortcut menu.
3. In the Commands and Options dialog, select the Format tab.
4. In the Number field, enter the following Excel number format:

#,##0.00

5. Click in any other field and then close the commands and Options dialog.

Hope this helps.
 
D

Dots

Dale,
Thanks! This WAS much easier than I had anticipated. Thanks so much for
your quick response!
 
D

Dale Howard [MVP]

Dots --

You are more than welcome for the speedy help. Commit this feature to
memory, so that you can amaze your friends and confound your enemies with
your knowledge!
 
A

Avi

Dale/Dots,

I am running into an issue with Data Analysis cost fields where they are
doing some weird rounding. Right now, without any formatting Project cost
$165,500 is showing up as 165,499.37. If I use the currency formatting, it
just adds a $ sign. Following your post, I thought I could use $#,##0 and get
no rounding, but using this results in $165,499.
How can I have Data Analysis show the correct $ figure as entered in Project
Pro i.e. in my case $165,500
Please help! Thanks!
 
Top