round down Pivot table calculated field

[woods2007]

Does anyone know how to round down the result of a calculated field in a pivot table?

See sum of average- I need this to round down to a whole no.

Excel Workbook
	A	B	C	D	E
3		Values
4	JobNo	Average of target	Sum of Qty	Sum of time taken	Sum of average
5	5286	1650	8949	405	1325.777778
6	5365	1650	20261	780	1558.538462
Sheet1

Excel 2010

Thanks in advance

Stephen

 

[Jerry Sullivan]

Stephen,

You should be able to add the RoundDown() function to the formula you currently have for the calculated field.

If that doesn't work for you, please post the calculated field formula.

If you just need to display the value rounded to the nearest whole number, you can do that simply by applying numberformatting to the cells.

 

[Robert Mika]

Does anyone know how to round down the result of a calculated field in a pivot table?

See sum of average- I need this to round down to a whole no.

Sheet1[TABLE="class: html-maker-worksheet"]
<thead>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[/TR]
</thead><tbody>[TR]
[TH]3[/TH]
[TD][/TD]
[TD]Values[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]4[/TH]
[TD]JobNo[/TD]
[TD]Average of target[/TD]
[TD]Sum of Qty[/TD]
[TD]Sum of time taken[/TD]
[TD]Sum of average[/TD]
[/TR]
[TR]
[TH]5[/TH]
[TD="align: right"]5286[/TD]
[TD="align: right"]1650[/TD]
[TD="align: right"]8949[/TD]
[TD="align: right"]405[/TD]
[TD="align: right"]1325.777778[/TD]
[/TR]
[TR]
[TH]6[/TH]
[TD="align: right"]5365[/TD]
[TD="align: right"]1650[/TD]
[TD="align: right"]20261[/TD]
[TD="align: right"]780[/TD]
[TD="align: right"]1558.538462[/TD]
[/TR]
</tbody>[/TABLE]
Excel 2010



Thanks in advance

Stephen

Try:
=ROUNDDOWN( 'Sum of average',0)

 

[woods2007]

Its worked- Had a ")" in the wrong place!

Thanks!

 

[Robert Mika]

Its worked- Had a ")" in the wrong place!

Thanks!

You are welcome.