Data Analysis-Truncating Hours to display Zero decimal places

[Bubba]

I have been building multiple data analysis views that reflect resource
forecasts for specified time periods. Many of the work hours are fractional
and will display as '1287.809298' hours. Is there a way to truncate this
value to display zero decimal places and simply '1287' hours. I have used
'commands and options' to set the default text display as 'fixed' for the
work hours in these views, which cuts the decimals to two places. I do not
see an option to truncate them to zero decimal places.

 

[Andrew Lavinsky]

Try this:

On the PivotTable, select Commands and Options in the Option Bar. Select
the appropriate field, and set the "Number" to "0." That will make it a whole
number for that data point.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[Dale Howard [MVP]]

Bubba --

Right-click on the column header of the the Work field and then select the
Commands and Options item. In the dialog, manually type the following
number format:

#,##0

The above formatting is the format used in Excel to show the command as the
thousands separator and to format the number with no decimal points.
Because you are working with an Excel PivotTable in PWA, you can actually
manually type Excel formating options to the numbers you display. Press the
Enter key on your keyboard to apply the Excel formatting and then close the
dialog. Hope this helps.

 

[Ben Howard]

Hi Bubba, set the format to #,#