Calculated field in pivot table returning zero value

[Excel Chimp]

I want to divide the Values below by a number. Here is the Calculated Field formula I created:
= Metric / 350

The calculated field returns a zero value rather than dividing the monthly value by 350.

What am I doing wrong? Thanks for any help.

---

[TABLE="width: 689"]
<tbody>[TR]
[TD]Sum of Actual[/TD]
[TD]Years[/TD]
[TD]Quarters[/TD]
[TD]Period[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Qtr1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Qtr2[/TD]
[TD][/TD]
[TD][/TD]
[TD]Qtr3[/TD]
[/TR]
[TR]
[TD]Metric[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[/TR]
[TR]
[TD]Capital / Renovation[/TD]
[TD="align: right"]99400.11[/TD]
[TD="align: right"]78859.41[/TD]
[TD="align: right"]60647.06[/TD]
[TD="align: right"]43823.06[/TD]
[TD="align: right"]41719[/TD]
[TD="align: right"]45228.92[/TD]
[TD="align: right"]35025.93[/TD]
[/TR]
[TR]
[TD]Contract Services[/TD]
[TD="align: right"]25027.81[/TD]
[TD="align: right"]30997.37[/TD]
[TD="align: right"]25291.67[/TD]
[TD="align: right"]25090.77[/TD]
[TD="align: right"]25318.17[/TD]
[TD="align: right"]23805.57[/TD]
[TD="align: right"]38848.42[/TD]
[/TR]
[TR]
[TD]Expenses[/TD]
[TD="align: right"]174679.38[/TD]
[TD="align: right"]185646.86[/TD]
[TD="align: right"]201316.93[/TD]
[TD="align: right"]194692.14[/TD]
[TD="align: right"]182040.95[/TD]
[TD="align: right"]188814.46[/TD]
[TD="align: right"]248376.36[/TD]
[/TR]
[TR]
[TD]Expenses Controllable[/TD]
[TD="align: right"]121012.94[/TD]
[TD="align: right"]132640.31[/TD]
[TD="align: right"]138118.63[/TD]
[TD="align: right"]142027.87[/TD]
[TD="align: right"]129541.07[/TD]
[TD="align: right"]134961.01[/TD]
[TD="align: right"]194100.51[/TD]
[/TR]
[TR]
[TD]Expenses Non-Controllable[/TD]
[TD="align: right"]53666.44[/TD]
[TD="align: right"]53006.55[/TD]
[TD="align: right"]63198.3[/TD]
[TD="align: right"]52664.27[/TD]
[TD="align: right"]52499.88[/TD]
[TD="align: right"]53853.45[/TD]
[TD="align: right"]54275.85[/TD]
[/TR]
[TR]
[TD]Income[/TD]
[TD="align: right"]409379[/TD]
[TD="align: right"]414060.69[/TD]
[TD="align: right"]428893.69[/TD]
[TD="align: right"]432460.37[/TD]
[TD="align: right"]421891.16[/TD]
[TD="align: right"]426456.11[/TD]
[TD="align: right"]426989.21[/TD]
[/TR]
[TR]
[TD]Make-Ready[/TD]
[TD="align: right"]7743.93[/TD]
[TD="align: right"]16849.3[/TD]
[TD="align: right"]14684.82[/TD]
[TD="align: right"]21820.14[/TD]
[TD="align: right"]18566.33[/TD]
[TD="align: right"]30265.68[/TD]
[TD="align: right"]42300.96[/TD]
[/TR]
[TR]
[TD]Capital other[/TD]
[TD="align: right"]12939.53[/TD]
[TD="align: right"]12279.64[/TD]
[TD="align: right"]15300.69[/TD]
[TD="align: right"]12781.66[/TD]
[TD="align: right"]12617.27[/TD]
[TD="align: right"]13970.84[/TD]
[TD="align: right"]14393.24[/TD]
[/TR]
[TR]
[TD]Marketing[/TD]
[TD="align: right"]6666.03[/TD]
[TD="align: right"]2326.69[/TD]
[TD="align: right"]6562.98[/TD]
[TD="align: right"]7394.96[/TD]
[TD="align: right"]4791.24[/TD]
[TD="align: right"]7718.42[/TD]
[TD="align: right"]5980.76[/TD]
[/TR]
[TR]
[TD]NOI[/TD]
[TD="align: right"]234699.62[/TD]
[TD="align: right"]228413.83[/TD]
[TD="align: right"]227576.76[/TD]
[TD="align: right"]237768.23[/TD]
[TD="align: right"]239850.21[/TD]
[TD="align: right"]237641.65[/TD]
[TD="align: right"]178612.85[/TD]
[/TR]
</tbody>[/TABLE]

 

[RoryA]

It looks as though your calculated field should be using 'Actual' rather than 'Metric' for its calculation.

 

[Excel Chimp]

It looks as though your calculated field should be using 'Actual' rather than 'Metric' for its calculation.

Yes, that's it! Thanks so much for replying.